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 dimension modeling?
Explain what is a cube in data warehousing concept?
Can you state some of the innovations throughout history?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
What is incremintal loading?
What is Operational Data Store?
What are the various transformation available?
What are the various file formats involved in reportnet?
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
Explain what is partitioning? What are the types of partitioning?
What are session timeout and application timeout? Where we have to do this process?
what is difference between scd2 and scd3