Explian the connected and unconnected lookup transformation
Answer Posted / hari
Connected lookup
1.input ports are connected through pipeline
2.we can have more inputs and more outputs
3connected lookup we can use both static and dynamic cache
4.if condition not match default it give values
Unconnected lookup
1. Inputs are connected through calling :LKP from expression
2.inputs are more and output returns one
3.only static cache can use
4.if condition not match it gives nulls
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Partition, what happens if the specified key range is shorter and longer
What are the different transaction levels available in transaction control transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is target load order?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to generate sequence numbers without using the sequence generator transformation?
What is the advantage of informatica?
What is fact table? Explain the different kinds of facts.
difference between repository database and repository service?
How to configure mapping in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is sequence generator transformation in informatica?