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
- 14937 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sushma
I go with Naveen's solution with a small change. I would
replace filter with Router TRFM.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are the different types of olap? Give an example?
Define mapping and session?
What is substr in informatica?
is it possible to index the data in cache of lkp transformation ?
What is a sorter transformation?
what is the complex transformation you used in informatica
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Why is sorter an active transformation?
What is expression transformation?
What are batches?
What are mapplets? How is it different from a Reusable Transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is meant by query override?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
