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
- 13608 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / himanshu
1. Lookup Transformation (Dynamic lookup enabled)
Use NewLookUpRow Attribute to determine if it is a
new(1),updated(2) or no change(0) record.
2. Update Strategy
Use condition on NewLookkUpRow value to Insert or Update
the record in the target or Reject it.
IFF(NewlookUpRow = 1, DD_Insert, IFF(NewlookUpRow =
2,DD_Update, DD_Reject))
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
Explain informatica architecture - version 8 / 9
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is meant by a domain?
What are the types of data warehouses?
What is primary and backup node?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What does “tail –f” command do and what is its use as an Informatica admin.
In how many ways we can create ports?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How do you change a non-reusable transformation to reusable transformation?
is it possible to index the data in cache of lkp transformation ?
What is data caches/ index caches?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
can u any challenge your project?
