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
- 14558 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
Separate from an archive server and a powerhouse?
What is informatica?
What do you mean by blocking transformation?
Differentiate between sessions and batches?
How to extract sap data using informatica?
Write the program through which the records can be updated?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
explain about unit testing? in real time?
In how many ways we can create ports?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what is song in infrmatica...?
What is the function of aggregator transformation?
What is mapplet in informatica?
Is there any way to read the ms excel datas directly into informatica?
where to store informatica rejected data? How to extract the informatica rejected data?
