What is difference between a connected look up and
unconnected look up?
Answer Posted / ande
Connected LookUp returns multiple values to other
Transformation whereas unconnected lookup return single
value, If condtion is match then connected lookup returns
user defined default values whereas unconnected lookup
returns null values, connected lookup supports dynamic as
well as static caches whereas unconnected lookup supports
static cache only
regards,
ande
| Is This Answer Correct ? | 52 Yes | 6 No |
Post New Answer View All Answers
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the reusable transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is meant by lookup transformation? Explain the types of lookup transformation?
What is powercenter on grid?
How to configure mapping in informatica?
What is different between the data warehouse and data mart?
How can informatica be used for an organization?
Which is the t/r that builts only single cache memory?
How do you load first and last records into target table?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the sequence generator transformation in informatica?
How do you set a varible in incremental aggregation
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?