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
How to call shell scripts from informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to delete duplicate row using informatica?
What do you mean by channel change?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is the size ur source like(file system or database)? how many record daily come u r banking project?
can you please explain me pre session and post session options?
What is DR strategy for Informatica project?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Mention few power centre client applications with their basic purpose?
What is the difference between source qualifier transformations source filter to filter transformation?
Differences between connected and unconnected lookup?
Differentiate between a database and data warehouse?
Difference between Data and Index Caches?