Wednesday, January 2, 2013

Unlabelled 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?

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?

by on




Ans.

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.

By at

No comments:

Post a Comment

Thank you :
- kareem

Subscribe to: Post Comments (Atom)