when will we go for unconnected lookup transformation in
Informatica?
Answer Posted / g. manthiramoorthy
1. Calling the same lookup multiple times in one mapping
2. Testing the results of a lookup in an expression
3. Filtering rows based on the lookup results
4. Marking rows for update based on the result of a lookup,
such as updating slowly changing dimension tables
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the fact table?
Explain what are the different types of transformation available in informatica.
What is the different lookup cache(s)?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How do you convert single row from source into three rows into target?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Name the different lookup cache(s)?
What is aggregator transformation in informatica?
What is the use of source qualifier?
what is index?how it can work in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to do unit testing in informatica?
What is update strategy transform?
Sequence generator, when you move from develoment to production how will you reset