Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Problem with CSV file : How to skip some column

user6390927Mar 28 2014 — edited Mar 28 2014

Hello,

I have an input CSV file on ODI. I have to intégrate it in an ORACLE table but i dont want all the columns.

How can i skip some column in my ODI interface ?

Ex:

CSV:

NAME;FISTNAME;ADRESS;PHONE;AGE

TABLE:

NAME;FISRTNAME;AGE

I only want to load the NAME, FIRSTNAME and AGE into my table and ignore the others columns.

Anyone has a solution please?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2014
Added on Mar 28 2014
#business-intelligence-applications, #data-integrator, #system-management-and-integration
6 comments
778 views