Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Connected and UnConnected
Lookup Transformation.Give me one or two examples please?
- 7 Answers
- 18986 Views
- I also Faced
- E-Mail Answers
Answer Posted / jaimeen shah
1) Connected lookup receives input values directly from the
pipeline whereas Unconnected lookup Receives input values
from the result of a :LKP expression
in another transformation.
2) You can use a dynamic or static cache in connected
lookup whereas in connected lookup you can use static cache
only.
3) In connected lookup, cache includes all lookup columns
used in the mapping (that is, lookup source columns
included in the lookup condition and lookup source columns
linked as output ports to other transformations) whereas in
unconnected lookup, Cache includes all lookup/output ports
in the lookup condition and the lookup/return port.
4) Connected lookup can return multiple columns from the
same row or insert into the dynamic lookup cache whereas
Unconnected lookup designate one return port (R). Returns
one column from each row.
5) In connected lookup, if there is no match for the lookup
condition, the PowerCenter Server returns the default value
for all output ports. If you configure dynamic caching, the
PowerCenter Server inserts rows into the cache or leaves it
unchanged.
In unconnected lookup, If there is no match for the lookup
condition, the PowerCenter Server returns NULL.
6) Connected lookup pass multiple output values to another
transformation. Link lookup/output ports to another
transformation.
Unconnected lookup pass one output value to another
ransformation. The ookup/output/return port passes the alue
to the ransformation calling :LKP expression.
7) Connected lookup supports default values in the port
whereas unconnected lookup doesn't support the default
values.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is InformaticaPowerCenter?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is a rank transform?
What is an expression transformation in informatica?
What do you mean by enterprise data warehousing?
What is the difference between a connected look up and unconnected lookup?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the different types of repositories created using informatica?
permutations of mapplet
Informatica Checkpoints
Quickly characterize reusable change?
What is the function of look up transformation?
Sequence generator, when you move from develoment to production how will you reset
can anyone suggest best free Talend data integration training online
