top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica: If Source Qualifier transformation populates two target tables, How to ensure TGT2 is loaded after TGT1?

+2 votes
618 views

Suppose we have a Source Qualifier transformation that populates two target tables. How do we ensure TGT2 is loaded after TGT1?

posted Jan 11, 2016 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

In the Workflow Manager, we can Configure Constraint based load ordering for a session. The Integration Service orders the target load on a row-by-row basis. For every row generated by an active source, the Integration Service loads the corresponding transformed row first to the primary key table, then to the foreign key table.

Hence if we have one Source Qualifier transformation that provides data for multiple target tables having primary and foreign key relationships, we will go for Constraint based load ordering.

enter image description here

answer Jan 11, 2016 by Manikandan J
0 votes

use mapping level property "Target Load plan" for set which table will load first

answer Jan 26, 2016 by Sanjay Patidar
...