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!

Perform Data Type Validation - ODI

3260599Sep 7 2016 — edited Sep 7 2016

Hi Experts,

I have requirement in my current project of performing the datatype validation in ODI on the source file.

in The target table the column is date datatype. here i want to check if the incoming value from the file is date type or no. Suppose the value is string in the file then it should be captured in the ODI error table.

How can i handle this using CKM at the datastore level.

Please give me your inputs.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2016

Added on Sep 7 2016

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

3 comments

577 views