Interested to Buy Any Domain ? << Click Here >> for more details...
S1 is having 1 lakh records and s2 is having 100 records,
s2 should compare s1 if emp no is same data should be
updated if not their it should insert the data.what are the
transformation used?
- 5 Answers
- 14805 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / k naveen kumar
Here we have to use lookup and update strategy and filter
Take s1 as source and take lookup on s2 just u will get the
output.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
How do you take back up of repository?
Why update strategy and union transformations are active? Explain with examples.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is DR strategy for Informatica project?
Mention few power centre client applications with their basic purpose?
What is mapplet in informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is a pre-defined event and user-defined event?
What are the designer tools for creating transformations?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
State the limitations where we cannot use joiner in the mapping pipeline?
What is a transaction control transformation?
Explain constraint based loading in informatica
What are the differences between source qualifier and joiner transformation?
What is a mapplet/worklet in informatica?
