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 |
Explain a mapping, session, worklet, workflow, mapplet?
What is metadata in context of a datawarehouse?
What according to you might be the future of data warehousing?
What is staging area?
Explain the different types of data warehousing?
What is the very basic difference between data warehouse and operational databases?
Is there any difference in testing database and data ware housing?
Explain what is cost benefit analysis (cba)?
How are the dimension tables designed?
Explain the difference between view and materialized view?
Explain is olap databases are called decision support system true/false?
What are the various methods of getting incremental records or delta records from the source systems?