explain about lookup t/r?
- 1 Answers
- 3814 Views
- IBM, I also Faced
- E-Mail Answers
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 |
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
difference between repository database and repository service?
What is the status code in stored procedure transformation?
How many repositories can we create in Informatica??
What is difference between partioning of relatonal target and partitioning of file targets?
What is lookup transformation?
What is a code page?
what is mapping parameter?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Why do we need informatica?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
What is the difference between stop and abort in informatica
Teradata 
