Interested to Buy Any Domain ? << Click Here >> for more details...
when will we go for unconnected lookup transformation in
Informatica?
- 6 Answers
- 24607 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 are pre and post-session shell commands?
How to go to the older version for a mapping?
What is the difference between router and filter?
Explain what transformation and how many are there in informatica?
What is blocking transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a standalone command task?
What is mapplet in informatica?
What is informatica worklet?
What is deployment group?
Different sorts of metadata that stores in the storage facility?
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?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are junk dimensions?
difference between informatica 8.1.1 and 8.6
