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

In the Type2 maping we have three options to recognise the newly added rows
Version number
Flagvalue
Effective date Range

  • Interview Candidate
  • 3
  • 6657

Showing Answers 1 - 3 of 3 Answers

rishi

  • Dec 14th, 2005
 

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.

  Was this answer useful?  Yes

Prasath

  • Oct 4th, 2007
 

Just use debugger to know how the data from source moves to target, it will show how many new rows get inserted else updated.

  Was this answer useful?  Yes

ASHOK1324

  • Apr 21st, 2009
 

In the SCD Type2, we have three options to recognise the newly added rows: 1. Version number 2. Flag value 3. Effective Date Range

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions