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
- 8900 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
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 ?
Do we need an ETL tool? When do we go for the tools in the market?
what is Forward,Reverse and Re_engineering?
what are the reporting tools and difference between them?
what is different between sequential batch and concurrent batch and which is recommended and why?
Explain about hash partitioning?
Is apache nifi an etl tool?
Identifying the bottlenecks in various components of Informatica and resolving them.
Compare ETL & Manual development?
How can we use external procedural logic in informatica?
Explain different types of partitioning?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
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?
what are the session parameters? How do u set them?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
