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

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

Tue, 08 July 2014 08:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I was going to suggest you to rename columns in the file (or, at least, try to enclose them into double quotes). As you can't modify the file, I don't have any other ideas.

Report message to a moderator

Re: How to extract data from a 'file' datasource with spaces in column headers in ODI [message #618169 is a reply to message #618146]

Wed, 09 July 2014 00:21

jainricha
Messages: 2
Registered: July 2014

Junior Member

Thanks for your response. The only alternative I could find is to Import the data in to Excel and then convert in to csv and then use that csv file as a datastore in ODI.
I was hoping in some way I could use the same text file.

Thanks,
Richa

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 05:02:02 CST 2024