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 the difference between stop and abort?

3 Answers   TCS,

what is curr val use for in sequence generator?

2 Answers   Emphasis,

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

Please let me know how to make encryption and decryption with example?

0 Answers  

what is runtime variable?

3 Answers   TCS,

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

Whats the difference between $, $$, $$$

9 Answers  

What is the benefit of session partitioning?

0 Answers  

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,