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 diff b/t sorter t/r and agg have the option sorter property...

0 Answers  

How to start a workflow using pmcmd command?

0 Answers  

what are challenges that you faced in testing? give solution to it?

1 Answers  

What are Rapid changing dimensions?

1 Answers  

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

What is Cognos script editor?

0 Answers   Cognizant,

Explain the different dimensions.

0 Answers  

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

how many data models u have done in informatica project?

2 Answers   TCS,