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
- 14551 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
Which is the t/r that builts only single cache memory?
What is a filter transformation?
What are the measure objects?
What are the uses of etl tools?
How will the document be delivered to me?
What is a router transformation?
Explain the mapping variable usage example in informatica
What is a standalone command task?
explan ur project architecture?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain the pipeline partition with real time example?
Please let me know how to make encryption and decryption with example?
How to update a particular record in target with out running whole workflow?
Differences between connected and unconnected lookup?
What is the reusable transformation?
