What is difference between a connected look up and
unconnected look up?



What is difference between a connected look up and unconnected look up?..

Answer / anil

Connected lookup

Unconnected
lookup

Receives input values diectly from the
pipeline

Receives input values from
the result of a

lkp expression in a
another transformation.

yoU can use a dynamic or static
cache U can use a static cache.

Cache includes all lookup columns used in the maping
Cache includes all lookup out put ports in the

lookup condition and the
lookup/return port.

Support user defined default
values Does not support
user defiend default values

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What is operational data store (ods)?

0 Answers  


What are the stages of datawarehousing?

0 Answers  


What are the possible data marts in retail sales?

0 Answers  


What is the main difference between inmon and kimball philosophies of data warehousing?

0 Answers  


What is meant by metadata in context of a data warehouse?

0 Answers  


In document how to create metrics?

0 Answers  


capital of tamilnadu

6 Answers   Wipro,


Explain in simple terms, the concept of Data Mining.

3 Answers  


Explain what are necessary tasks to install reportnet software?

0 Answers  


What are aggregate fact tables ? why they are needed? give an example

2 Answers  


Explain which columns go to the fact table and which columns go the dimension table?

0 Answers  


OLAP architecture?

1 Answers   CTS, Honeywell,


Categories