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
- 9027 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 ETL Testing Operations?
how do u extract data from different data sources explain with an example?
what make u disappointmnets in u r career
what is the meant by Normalization and de-normalization?
Do we need an etl tool?
what is the use of server manager?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What is lookup table in etl testing?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
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.
where we cannot use sorter Transformation. if we use then we will not get correct data?
State the differences between shortcut and reusable transformation
explain the methodology of Data Warehousing?(Polaries)
What are the key benefits of ETL Testing?
What are your responsibilities as an etl tester?
