What is diff between connected and unconnected lookup?
Answer Posted / kalu bhai
CONNECTED look up:
>> It will patispated in data pipeline
>> It contain maltible inputs and maltible outputs.
>> It supported flat file and relation table
>> It supported static and dynamic cache.
UNCONNECTED LOOK UP:
>> It will not patispated in data pipeline
>> It contain maltible inputs and single output.
>> It supported relation table only
>> It supported staticcache only.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
EXL informatica Questions
Explain lookup transformation in informatica
Explain the features of connected and unconnected lookup.
Explain how many types of dimensions are available in informatica?
What are active and passive transformations?
What will be the approach?
Differentiate between Load Manager and DTM?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
how we can load rejected record's at run time?(not through bad files)
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. ?
Implementation methodology
What is the need for an etl tool?
What do you understand by a term domain?
What is primary and backup node?
What is sq transformation?