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 a Data Warehouse?

9 Answers  


What are the key columns in Fact and dimension tables?

0 Answers  


OLAP architecture?

1 Answers   CTS, Honeywell,


What is a star schema? Why does one design this way?

3 Answers  


What are different deliverables according to phases?

0 Answers  






What is degenerate dimension table?

0 Answers  


What is cost benefit analysis (cba)?

0 Answers  


What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

6 Answers   ACS,


Explain the hierarchies level data warehousing.

0 Answers  


Write a short note on data warehousing & three-Tier Warehouse architecture in detail.

1 Answers  


What is the 4 + 1 view model as it relates to system modeling?

0 Answers  


How can we import and export using BCP utility?

1 Answers  


Categories