Answer Posted / swetha
Use lookup transformation in u'r mapping to lookup data in a
relational table, view, synonym.
Informatica server queries the look up table based on the
lookup ports in the transformation. It compares the lookup
transformation port values to lookup table column values
based on the look up condition.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
explan ur project architecture?
What is lookup transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the new features of informatica 9.x in developer level?
Define filter transformation?
What is the procedure for creating independent data marts from informatica 7.1?
What is primary and backup node?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Define update strategy?
What is a rank transform?
Explian the Process of deployment groups in informatica
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How to partition the Session?
Explain your project of banking domian.
What is the surrogate key?