Hi Team,

I face issues while loading Type 2 dimension table.

1. Its normal scenario where upon existence of record in target table, we update the record if any change in business key
2. If the record doesnt exists then we insert the record i target table.

Now in informatica this can be achieved using Router based on the condition.
So, in router we will end up creating 2 groups one for Insert and other for Update.

While I ran my job, what informatica is doing that it is inserting the record first and then updating .


I have made sure that when i create groups, I have update group before Insert. But still informatica is first inserting the record . This is causing the job to fail throwing AK constraint error.

Can anybody provide solutions for this.