Implementing SCD Type2

In SCD Type2 scenario, Informatica has no control on the DML operation.
How will we make sure that updates happen before Inserts in SCD Type2 dimension so that we can avoid the AK constraint error.

Questions by PoonamK

Showing Answers 1 - 3 of 3 Answers

You can try to change the name of the target instances.
For example, let us consider we have 2 instances of targets CUST_D (insert) and CUST_D1 (update), try to change the name of insert instance to CUST_D2. You can view the target load plan after and before the changes (expanding the SQ) also you can view it in the monitor while running the mapping.

Thanks,
Abhilash

  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