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
Answer Posted / swetha
we can use sequence generator with cycle for that
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is a materialized view log?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What is the difference between project backlog and product backlog?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Explain and compare etl & manual development?
Compare ETL & Manual development?
What are the different etl testing categories as per their function?
explain the methodology of Data Warehousing?(Polaries)
what are the concerns of OLTP and DSS systems?
how do u set partition points in the mapping?
How to fine tune mappings?
What is virtual Data Warehousing?
What is etl process. How many steps etl contains explain with example?
what is data modeling?
What are the various tools used in etl?