when will we go for unconnected lookup transformation in
Informatica?
Answer Posted / kamesh
The main advantage of using an unconnected lookup is the fact that you can use it in an expression/any other transformation like a “function” in other programming languages. The Lookup Cache is calculated only once as part of the session initialization and hence more efficient, since all subsequent look-ups will re-use the Cache.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the commit type if you have a transaction control transformation in the mapping?
can you please explain me pre session and post session options?
Explain target update override in informatica
How to update a particular record in target with out running whole workflow?
Performance tuning in UNIX for informatica mappings?
What is an expression transformation in informatica?
Name the different lookup cache(s)?
How to use pmcmd utility command?
How can informatica be used for an organization?
What is a joiner transformation?
What are the tasks that can be performed using sq?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How can repository reports be accessed without sql or other transformations?
What are the measure objects?