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?
Differences between version 7.x and 8.x.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain in detail scd type 2 through mapping.
Does an informatica transformation support only aggregate expressions?
What is a code page?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what is the complex transformation you used in informatica
scenario where i can use only concurrent execution of workflow.
What is the difference between a repository server and a powerhouse?
Briefly explain the aggregator transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Is it possible to create multiple domains on a single Informatica server?
What is meant by pre and post session shell command?
What is a shortcut and copy in Informatica and how two are different with each other?