To Load source records from DEP
table to target in a cyclic order.
In this scenario we will load the records present in the DEP
table to Flat files in a cyclic order such that the first record will go to
TargetFile01 ,2nd to TargetFile 02 ,3rd to Target File03
and 4th record again to TargetFile01.
For implementing this we
can make use of sequence generator with
properties as given below.
You can route the records
based on the NEXT VAL of sequence Generator using a Router as given below.
The overall mapping will
look like this.
Below is the expected
format in which target files will be created.
Please read more of such
scenarios at http://dwhlaureate.blogspot.in/2013/02/informatica-scenarios-based-questions.html
Wonderful
ReplyDeleteNice blog thanks for sharing.
ReplyDeleteIn Sequence Generator properties, current value should be less than the end value. Then how can we set both of them as 3.
ReplyDelete