top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Loading Target Tables

+1 vote
259 views

Suppose we have two Source Qualifier transformations SQ1 and SQ2 connected to Target tables TGT1 and TGT2 respectively. How do you ensure TGT2 is loaded after TGT1?

posted May 4, 2015 by Sunil

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

1 Answer

0 votes

If we have multiple Source Qualifier transformations connected to multiple targets, we can designate the order in which the Integration Service loads data into the targets.

In the Mapping Designer, We need to configure the Target Load Plan based on the Source Qualifier transformations in a mapping to specify the required loading order.

answer May 7, 2015 by Shweta Singh
Similar Questions
+1 vote
Loading the target tables

If suppose I have source with seven records from that first three must go in 3 target instances and 4th record again have to go into first target how can I achieve it?

+1 vote
Informatica: If session fails after loading 10000 records in the target, how can we load 10001 the record when run next?

If session fails after loading 10000 records in the target, how can we load 10001 the record when we run the session in the next time?

+1 vote
Loading 5 flat files of having same structure to a single target

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

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

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

...