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
is it possible to index the data in cache of lkp transformation ?
Explain target update override in informatica
Explain the aggregator transformation?
what is mean by complex business rule ?
What are the different versions of informatica?
How to handle decimal places while importing a flatfile into informatica?
What is the function of look up transformation?
Explain the informatica workflow?
How to extract sap data using informatica? What is abap? What are idocs?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What does cheating measurement mean?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Why is sorter an active transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?