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?
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
differences between service based and product based?
What are the modules in Power Center
How to improve the performance of a session using sorter transformation?
What is the surrogate key?
my source is junk data how will u remove that junk data by using unix please any one replay me
Where do we use mapping variables in informatica?
Explain sessions. Explain how batches are used to combine executions?
What is update strategy transform?
What is union transformation?
What are the components of the workflow manager?
Define update strategy?
Is it possible to revert a global repository to local one and why?
Differentiate between sessions and batches?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you use reject loader.