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
Did u used latest transformations of 8.6.0? for what?
Explain lookup transformation in informatica
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Can informatica load heterogeneous targets from heterogeneous sources?
How can you define user defied event?
can anyone explain me about retail domain project in informatica?
What are the modules in Power Center
What is the maplet?
How to go to the older version for a mapping?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is xml source qualifier transformation in informatica?
What is the surrogate key?
How do you use reject loader.