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
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is exclusive and normal mode for repository services?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the commit type if you have a transaction control transformation in the mapping?
What are the main issues while working with flat files as source and as targets ?
Plz can any one say me how to get the informatica certification materials and dumps
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Performance tuning in UNIX for informatica mappings?
define galaxy repository in informatica
What is the difference between informatica 7.0 and 8.0?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can you generate sequence numbers without using the sequence generator transformation?
What are the differences between oltp and olap?
How can we use mapping variables in informatica? Where do we use them?