we have 1 source table containing 100 records. now we have to transfer first s

we have 1 source table containing 100 records. now we have
to transfer first set of 1-10 (i.e1-10) records to one
target table and another set of 1-10(11-20) records to
other target table and continue like that till 100th record

Question Posted / coolani

3 Answers
7815 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10)..

Answer / zslstar

we can use the sql below to indicate the rownum.
then router the data according to the rownum from upstream.

select t.*,rownum rn from test t
where mod(floor(t.rn/10),2) =0 --get the rows whose rownum
between 1~9,20~29,etc.

Is This Answer Correct ?

11 Yes

1 No

we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10)..

Answer / swetha

we can use sequence generator with cycle for that

Is This Answer Correct ?

4 Yes

3 No

we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10)..

Answer / kvikas2056

Use seq. Generator to create sequence or you can use expression transformation to create sequence, then in router transformation create 10 group and give conditions like seq >1 and seq <11, seq>11 and seq <20 etc.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer