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
What is the difference between informatics 7x and 8x and what is latest version?
Which is the t/r that builts only single cache memory?
What is meant by active and passive transformation?
without table how to come first record only in oracle?
What is the sequence generator transformation in informatica?
Is stop and abort are same in informatica?
Why filter transformation is an active one?
what is index?how it can work in informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
To import the flat file definition into the designer where should the flat file be placed?
What is dimensional table? Explain the different dimensions.
What are the advantages of using informatica as an etl tool over teradata?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
expain about the tune parameters?
What are the different transaction levels available in transaction control transformation?