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
What is the command used to run a batch?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Differentiate between a database and data warehouse?
What is powercenter on grid?
Explain the features of connected and unconnected lookup.
Can we create a node as a gateway node and the same node can be assigned to a grid?
Does an informatica transformation support only aggregate expressions?
what are 3 tech challenges/ common issues you face?
Where is metadata stored?
What is session task and command task?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is meant by lookup transformation? Explain the types of lookup transformation?
Separate from an archive server and a powerhouse?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Which is the t/r that builts only single cache memory?