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
- 14570 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 different versions of informatica?
Explain sessions. Explain how batches are used to combine executions?
What is informatica? Why do we need it?
How can you generate reports in informatica?
What is meant by incremental aggregation?
Write the program through which the records can be updated?
What do you mean by channel change?
What is meant by target load plan?
What is deployment group?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How to join three sources using joiner? Explain though mapping flow.
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the tuning techniques you applied during your last project
server hot-ws270 is connect to Repository B. What does it mean?
How does a sorter cache works?
