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...

What is confirmed dimension and fact?

7 Answers  

What could be the possible resons of locks by user?

0 Answers  

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

What is the Rank index port in Rank transformation?

0 Answers   Informatica,

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

Informatica and datawarehousing courses in Pune?

2 Answers  

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

What are junk dimensions?

0 Answers  

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

How do you convert single row from source into three rows into target?

0 Answers