Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 8842 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / swetha
we can use sequence generator with cycle for that
| Is This Answer Correct ? | 4 Yes | 3 No |
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 |
what is Forward,Reverse and Re_engineering?
Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?
1 Answers IBM, Saama Tech, Wipro,
what are the parts of Informatica server ?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Compare etl & elt?
What is a mapping?
Hi, Lookup() is what kind of join ?
what is the use of server?
when should one create lookup transformation ?
What are cubes and olap cubes?
dimension object created in oracle can be imported in designer?how?
what are the reporting tools and difference between them?
Teradata 
