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 resilience time?
What are the components of workflow manager?
what is the difference between informatica6.1 and infomatica7.1
Mention a few design and development best practices for informatica?
What is the command used to run a batch?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is informatica etl tool?
have u done any performance tuning? how u ll do?
In which transformation you cannot drag ports into it?
What are the designer tools for creating transformations?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the limitations of joiner transformation?
Name the different lookup cache(s)?