How can u recognise whether or not the newly added rows in the source r gets insert in the target ?





If it is Type 2 Dimension the abouve answer is fine, but if u want to get the info of all the insert statements and Updates you need to use session log file where you configure it to verbose.
You will get complete set of data which record was inserted and which was not.

No comments:

Post a Comment