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
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Explain scd type 3 through mapping.
Explain what transformation and how many are there in informatica?
How to extract sap data using informatica? What is abap? What are idocs?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How does the aggregator transformation handle null values?
Difference between Target-based loading and constraint-based loading?
what is the -ve test case in your project.
What is a connected transformation?
What are the differences between oltp and olap?
Explain why we use partitioning the session in informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is incremental aggregation?
What is the difference between informatica 7.0 and 8.0?