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!

Data Validation in ODI.?

SanthoshSreshtaApr 1 2016 — edited Apr 1 2016

Hi Experts,

I am loading some excel files data to ORACLE DB, I am loading 100 files of same structure in one folder to one table.
Now I need to do data validation .. I need to check the total amount coming from file and amount which is been loaded in DB.?
Is it possible to check like that..?
And also I need to check as If it is only STRING datatype then only the data should load.
and also I need to check as If the column data has length 10 only then only data should load... if not it should skip the not compatible records and error records information should get into file.....??

FYI, I have no Primary Keys and Foreign Keys for the EXCEL files am loading.

I am using ODI 11.1.1.9

Thanks a Million,

Santhosh S.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2016

Added on Apr 1 2016

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

2 comments

717 views