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 |
What is a Data Warehouse?
What are the key columns in Fact and dimension tables?
OLAP architecture?
What is a star schema? Why does one design this way?
What are different deliverables according to phases?
What is degenerate dimension table?
What is cost benefit analysis (cba)?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Explain the hierarchies level data warehousing.
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
What is the 4 + 1 view model as it relates to system modeling?
How can we import and export using BCP utility?