Whenever we have only one Source Qualifier transformation and multiple targets , our approach in specifying the order of the target is by using the property called "Constraint based loading".
By enabling the Check box the targets will be loaded in a way like the master table is loaded first and then the depending tables .
If we have more than one Source Qualifier transformation then we have to use Target Load plan.
By enabling the Check box the targets will be loaded in a way like the master table is loaded first and then the depending tables .
If we have more than one Source Qualifier transformation then we have to use Target Load plan.
This comment has been removed by a blog administrator.
ReplyDelete