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
- 8696 Views
- I also Faced
- E-Mail Answers
Answer Posted / kvikas2056
Use seq. Generator to create sequence or you can use expression transformation to create sequence, then in router transformation create 10 group and give conditions like seq >1 and seq <11, seq>11 and seq <20 etc.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the concerns of OLTP and DSS systems?
what is the difference between cubes and package in cognos
Explain and compare etl & manual development?
List few etl bugs?
What is partitioning? Explain about round-robin, hash partitioning.
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
what are the production issues in datastage?
What is etl tool in hadoop?
How etl testing is different from database testing?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is the difference between cardinality and Nullability?
What are the types of Data Warehouse applications?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What is cube grouping?
Explain about the data integration suite features?
