Hi friends,
I just did one interface and it got executed successfully, as a result when i checked the end target table i found that the data is not loaded inspite of the error free run interface.
When i inspected the reason behind the problem, then i found that in the I$ table itself the data hasnt got inserted from the code that i verified. This is the code behind it
Though there is a problem in join for the above code, i couldnt execute the above code in toad/sql developer inorder to check with the problem because of the absence of the below tables
.C$_0F_
Since ODI is deleting those table after using temporarily once the interface executed successfully. How i can make to retain the above tables by making the ODI not to delete so that i can check the problem behind my issue in the query.
Thanks in advance.
Regards,
Saro