Answer / manthiramoorthy. g

S-SQ-EXP-SEQ-RTR-Tgt1,Tgt2,Tgt3

In Router: (Group Condition)
MOD(nextval,3)=0 Connect To Tgt1
MOD(nextval,3)=1 Connect To Tgt2
MOD(nextval,3)=2 Connect To Tgt3

Answer / teja_dwh

By using sequence generator properties we can do this.
setting the properties like below
start value:1
end value:3
cycle:yes
reset:yes
increment by:1
we can achieve the result by this way.

cheers
teja

Answer / rucha

i will use a sequence generator to get the row number then
input this sequence numbers to an expression transformation
where i will give an if condition (row number mod 3) then
the result be stored in a variable port say x.this variable
port value is filtered using router transformation as rows
with x=1 in group1,x=2 in group 2 and x=3 in default. the
resultant groups are connected to the targets 1,2 and 3
respectively

Answer / gyana

source--->sq--->attached a sequence generator with settings

current value=1
start value=1
end value=3
incrimented by=1
cycle=yes

------->router(3groups)--->3 targets

Answer / koti

hi rucha could u tell me how the mod function can works and
how it will gives answer 1 or 2 or 3 only...

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,

What is the command used to run a batch?

0 Answers  

what are the row and column separations in Flat Files

3 Answers   CTS,

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

What is lookup change?

0 Answers  

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

How to load relational source into file target?

3 Answers   IBM,

How do you use reject loader.

0 Answers  

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

 Informatica Checkpoints

0 Answers   DELL,

How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,