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
What is decode in informatica?
Why update strategy and union transformations are active?
What are the main features of Oracle 8i with context to datawarehouse?
How can one identify whether mapping is correct or not without connecting session?
How to join three sources using joiner? Explain though mapping flow.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What differs when we choose the sorted input for aggregator transformation?
What is transformation?
Did u used latest transformations of 8.6.0? for what?
How will the document be delivered to me?
What the difference is between a database, a data warehouse and a data mart?
what is unit testing?tell me proceedure
What is a joiner transformation and why it is an active one?
What is union transformation?
Write the unconnected lookup syntax and how to return more than one column.