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
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Define the various join types of joiner transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How can you validate all mappings in the repository simultaneously?
Write the unconnected lookup syntax and how to return more than one column.
How you can differentiate between connected lookup and unconnected lookup?
What is powercenter on grid?
How can you increase the performance in joiner transformation?
What is the function of look up transformation?
How many ways are there to do 'remove duplicate records in informatica'?
What are multi-group transformations?
What is repository manager?
Explain the tuning lookup transformation - informatica
Parameter and variable differences
What is confirmed fact in dataware housing?