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
- 8699 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the various tools used in etl?
What are cubes and olap cubes?
Explain do we need an etl tool?
what are the concerns of OLTP and DSS systems?
Compare ETL & Manual development?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what are the concerns of OLTP and DSS systems?
what is the meant by Normalization and de-normalization?
What is full load & incremental or refresh load?
How can we use external procedural logic in informatica?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What is a lookup table in etl?
how do u implement configuration management in Informatica?
Explain about power designer data modeling software?
Explain the difference between etl tool and olap tools?
