Hello, I have a simple interface, I am loading data within same oracle database from one schema to another schema.
But I see 3 rows less.
Can some body please advice how to see rows that are not loaded,what was reason etc.
You can also see it within ODI by opening the Model --> right-clicking your target datastore -->Check --> Errors...
It shows you the table E$_ table for this specific datastore. For each rejected row, you will see the whole set of columns plus the reason of the rejection.