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
- 8833 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
Compare ETL & Manual development?
How etl testing is different from database testing?
What is a mapping, session, worklet, workflow, mapplet?
What is initial load and what is full load?
what is pmrep command?
Explain about enterprise scalability and roi of data integration suite?
In Which Transformation We Can Use Having Clause In Informatica?
Difference between flat files and relational sources?
how do u implement configuration management in Informatica?
How many steps etl contains explain with example?
What is the difference between round-robin partitioning and hash partitioning?
What are the steps involved in etl process?
What is the difference between project backlog and product backlog?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are dimensions?
