Answer Posted / suraj kedia
Look up t/r is used in a mapping to look up data in a
relational table,flat file,view or synonym.
The informatica server queries the look up source based on
the look up ports in the transformation.It compares look up
t/r port values to look up source column values based on the
look up condition.
Look up t/r is used to perform the below mentioned tasks:
1) To get a related value.
2) To perform a calculation.
3) To update SCD tables.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the tasks that source qualifier perform?
What are the different components of powercenter?
What are data-driven sessions?
State the limitations where we cannot use joiner in the mapping pipeline?
Repository user profiles
explain abt ur project architecture?
In which transformation you cannot drag ports into it?
Briefly describe lookup transformation?
Differentiate between reusable transformation and mapplet.
What is mapplet in informatica?
Explain Dataware house architecture .how data flow from intial to end?
What is informatica etl tool?
How to go to the older version for a mapping?
What do you mean by blocking transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?