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 / 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 is cube grouping?
What are the differences between sql override and update override?
What is a mapping, session, worklet, workflow, mapplet?
what is pmrep command?
How to increase performance without changing anything in mapping.( In prod)
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
What are your responsibilities as an etl tester?
what is the use of server?
What is a materialized view log?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Explain what are the various etl tools in the market?
Explain and compare etl & manual development?
Define slowly changing dimensions (SCD)?
What is tracing level? How many types of transformations supported by sorted input?
When do we analyze the tables?