I am new to ODI, in my process could be called in 2 modes Validation and Load
a. Validation – V – would perform the validation on the source data based on the filter criteria
b. Load – L – would perform some mandatory check and load the data in target table
my concern is how should i do only validation on source data,Please share any ideas regarding this...
Thanks in Advance...
What kinda validation you need ?
YOu can right click on datastore and go for check or else you can drag the datastores to a package and even check it there. You can also create constraints as per your requirement and check it.
The error records will be inserted into E$ table if found. Very nice article written here
Thank you for reply,in my process i need to check the mode its VALIDATION or LOAD,up to here i know how to do after that ,once i choose mode VALIDATION, how should do validation with out loading,can you please explain me detail steps or any small hint
By dragging datastore in package in order to apply static control, you're doing your validation without loading.
This validation step will copy the no-valid data into error table (E$) and you can also decide if you want to delete them from the source (and keep the data only in the error table).