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
Can we create a node as a gateway node and the same node can be assigned to a grid?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the commit type if you have a transaction control transformation in the mapping?
What is aggregate cache in aggregator transformation?
What is the use of transformation?
what is degenerated dimension?
Explian the Process of deployment groups in informatica
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to load the data from people soft hrm to people soft erm using informatica?
What does cheating measurement mean?
how many types of dimensions are available in informatica?
What are active transformations.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is dimensional table?
What happens when a session fails and you click on recover?
