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 are the various types of transformation?
Target increases every day even though no new record was inserted
how to create user defined function (udf) in informatica
tell me the rules and responsblites in our project(my project is development)
How does a sorter cache works?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is status code in informatica?
Why do you use Mapping Parameter and mapping variable?
Explain the informatica workflow?
How to generate or load values in to the target table based on a column value using informatica etl tool.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Is stop and abort are same in informatica?
How many numbers of sessions can one group in batches?
What are the different clients of powercenter?
what is the -ve test case in your project.