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 differs when we choose the sorted input for aggregator transformation?
How to do unit testing in informatica? How to load data in informatica ?
What is exclusive and normal mode for repository services?
What are the main features of Oracle 8i with context to datawarehouse?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the differences between a connected lookup and unconnected lookup?
Where do we use mapping variables in informatica?
expain about the tune parameters?
Explain in detail scd type 2 through mapping.
What is domain and gateway node?
What is session task and command task?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is the use of target designer?
where to store informatica rejected data?