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 etl process. How many steps etl contains explain with example?
What are the types of Data Warehouse applications?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
how do u identify the changed records in operational data?
List few etl bugs?
what are the session parameters? How do u set them?
what is the use of server manager?
What are the various tools used in etl?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Difference between flat files and relational sources?
When do we analyze the tables?
What is lookup table in etl testing?
can cubes contain measures ?
What is grain of fact?
What is tracing level?