Informatica Interview Questions and Answers, Informatica Real time Issues and Scenarios.
Q: How to Avoid Duplicates Records in target Table by Using Lookup?
Answer: Below are the ways to find that:
1. Connected lookup: Use a Connected lookup with Enabled Dynamic Cache. and Please check the Output Port of the NewlookupRow(Which WIll be Inserted into the target Table). lookup will Decide whether the incoming record is existed or not in the table cache?
2.UnConneted Lookup: Create An UnConnected Lookup. and Call the lookup in Expression Transformation and Please Check the Lookup Condition Port Value(NULL/NOT NULL) to decide whether the incoming record already existed in the target table or not?
No comments:
Post a Comment