Hope you choosen File technology from Topology>Physical Arhchitecture>Technologies
If not, please slect the file technology from topology.
before you reverse engineer, please analyze the data in CSV file and provide the data type and column length in ODI level.
First of all you reverse engineer the file with single column and then you can split it into multiple columns and provide the related data type and column lenth and do the reverse engineer, later right click on file type table>data>view
In data view there is no data means, interface will execut successfully with zero records insertion
hope this may helps you to fix
Thanks for your reply...
I had done the same which you have suggested...
Actually I am working on ODI in UNIX environment. So I went for Record Separator option as UNIX in Files tab of the Datastore and now its working fine...
Anyways once again thanks for your response..
Thanks & Regards,