Interested to Buy Any Domain ? << Click Here >> for more details...
when will we go for unconnected lookup transformation in
Informatica?
- 6 Answers
- 24256 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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
What is session task and command task?
Under which circumstances, informatica server creates reject files?
What is informatica? Why do we need it?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a joiner transformation?
What is different between the data warehouse and data mart?
What do you understand by a term domain?
How can you generate reports in informatica?
What differs when we choose the sorted input for aggregator transformation?
How to update a particular record in target with out running whole workflow?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is pmcmd command?
How to partition the Session?
How would you copy the content of one repository to another repository?
How can we update a record in the target table without using update strategy?
