OraFAQ Forum: Data Integration » How to extract data from a 'file' datasource with spaces in column headers in ODI

Home » Developer & Programmer » Data Integration » How to extract data from a 'file' datasource with spaces in column headers in ODI (11.1.1.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to extract data from a 'file' datasource with spaces in column headers in ODI [message #618104]

Tue, 08 July 2014 00:47

jainricha
Messages: 2
Registered: July 2014

Junior Member

Hello All,

I am trying to do a File to Table Mapping. The source file has column headers with spaces, for instance, column name is like HOME NATURAL ACCOUNT.So while running the Interface, it's throwing error like :

ODI-1227: Task SrcSet0 (Loading) fails on the source FILE connection Linux_Server_File_Path.
Caused By: java.sql.SQLException: ODI-40481: Invalid COL ALIAS ""NATURAL ACCOUNT C4_HOME_NATURAL_ACCOUNT"" for column "HOME"

The source file shouldn't be altered. So is there any other way out to read the file, without altering the existing file columns.

Thanks.

Report message to a moderator

[Message index]

		How to extract data from a 'file' datasource with spaces in column headers in ODI By: jainricha on Tue, 08 July 2014 00:47
		Re: How to extract data from a 'file' datasource with spaces in column headers in ODI By: Littlefoot on Tue, 08 July 2014 08:29
		Re: How to extract data from a 'file' datasource with spaces in column headers in ODI By: jainricha on Wed, 09 July 2014 00:21

Previous Topic:	Unit testing framework
Next Topic:	Books for Biggner

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 14:30:34 CDT 2024