How to extract data from a 'file' datasource with spaces in column headers in ODI [message #618104] |
Tue, 08 July 2014 00:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d309515035313b35535e5bfde9fe0088?s=64&d=mm&r=g) |
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.
|
|
|
|
|