Explian the connected and unconnected lookup transformation
Answer / 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 |
What are the types of metadata that stores in repository?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
What is a test load?
What is InformaticaPowerCenter?
What is the Process to creating lookup transformation in informatica
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
How do you do error handling in Informatica?
How to generate sequence numbers?
How can you change from reusable session into non-reusable session.
Can we insert ,update ,delete in target tables with one update strategy tran.?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is power play plug in?