This content has been marked as final. Show 4 replies
What kinda validation you need ?1 person found this helpful
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).
Sorry for delay its working fine ,Thank you