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 |
Informatica and datawarehousing courses in Pune?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
how the server recognises , if the session fails after loading the 100 records in to the target
What are the different options available for update strategy?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
What is informatica?
How can we store previous session logs?
What are the types of lookup?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
what is target load plan
guys which is the best institute in banglore to learn informatica??