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
- 8134 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
Explain etl mapping sheets?
What is abap? What are idocs?
what do u do when DB time takes more?in sap bi
if i have a query as flat file how can we load data to target table
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Can we create Hierarchies in generic datasources?
Explain about hash partitioning?
Mention few test cases and explain them?
Define Dynamic push down optmization?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What is the difference between project backlog and product backlog?
Explain the key challenges that you face while performing etl testing.
when will use SQL override in a lookup transformation?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
How can we use external procedural logic in informatica?
