What is diff between connected and unconnected lookup?
Answer Posted / venkatesh reddy
connected lookup:
It is used to join the two tables
it returns multiple rows
it must be in mapping pipeline
u can implement lookup condition
using connect lookup u can generate sequence numbers by
enabling dynamic lookup cache.
unconnected lookup:
it returns single output through return port
it acts as a lookup function(:lkp)
it is called by another t/r.
not connected either source r target.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can anyone explain me about retail domain project in informatica?
What is incremental aggregation?
How many ways are there to create ports?
what is INFORMATICA TESTING process
Explain about cumulative Sum or moving sum?
Explain the different dimensions.
what are the Methods For Creating Reusable Transformations?
How you prepared reports for OLAP?
Why update strategy and union transformations are active? Explain with examples.
What is a filter transformation?
What are the components of workflow manager?
How do you load first and last records into target table?
How can a transformation be made reusable?
What differs when we choose the sorted input for aggregator transformation?
What is the surrogate key?