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
- 8902 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
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
How to fine tune mappings?
Can there be sub steps of etl steps?
explain the methodology of Data Warehousing?(Polaries)
Define Dynamic push down optmization?
Mention few test cases and explain them?
What is a staging area? What is the purpose of a staging area?
what make u disappointmnets in u r career
SCD2 will work on only dimension tables as well as fact Table?
flat filevalidation in informatica
what is the use of structures?how many nodes can u create in a structure?
How can we use external procedural logic in informatica?
how do u identify the changed records in operational data?
What is data modeling and data mining?
where are the log files generally stored.Can you change the path of the file.what can the path be?
