when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
Answer Posted / jeevan kumar medapati
if u want to perform look up on less values then we go for
connected lkp
if u want to perform look up from more than one table then
we go for un connected lkp
in ur source u have more date columns then we should go for
unconnected lkp.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Suppose we do not group by on any ports of the aggregator what will be the output?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
define galaxy repository in informatica
which one is better performance wise joiner or look up
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is status code in informatica?
Explain lookup transformation is active in informatica
What are connected or unconnected transformations?
Briefly explain the aggregator transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is informatica worklet?
Define enterprise data warehousing?
Explain direct and indirect flat file loading (source file type) - informatica