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
- 14941 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
What is depict expression change?
what are the Methods For Creating Reusable Transformations?
what are 3 tech challenges/ common issues you face?
Mention few power centre client applications with their basic purpose?
What is the difference between Active and Passive transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is the cumulative sum and moving sum?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the uses of etl tools?
What is an expression transformation in informatica?
Write the different tools in the workflow manager?
Explain scd type 3 through mapping.
What is the difference between source qualifier transformations source filter to filter transformation?
What are the different types of olap? Give an example?
