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

Which files are created during the session rums by informatics server?

0 Answers  

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

Explain the code page compatibility?

0 Answers  

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

Difference between session variables and workflow variables?

2 Answers   Informatica,

What is operational data source (ODS)?

7 Answers  

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

What is joiner transformation in informatica?

0 Answers  

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

What are the types of caches in lookup? Explain them.

0 Answers  

Why is sorter an active transformation?

0 Answers  

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers