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!

Flat file (csv) to oracle database - how to validate source data?

963952Oct 1 2012 — edited Oct 4 2012

Hello,

I have source csv file and its contens should be imported to oracle data table. Also, I need to perform some source data validation, for example - there is csv column named "Count" and - of count <10 - data from entire row will be saved to oracle table. If count >=10, data row should not be written to oracle table, instead - it should be created as invalid data and appended to error table.

End also:
- if my scenario will complete with some validation errors, system administrator should receive mail with number of invalid rows
- after import from csv, source data from csv file should be deleted (to prevent load them next time) - there are no any ids in csv, only text data

Is this possible with ODI? Can you provide any tips how can I do this? Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2012

Added on Oct 1 2012

#business-intelligence-applications, #data-integrator, #system-management-and-integration

16 comments

1,653 views