What is difference between a connected look up and
unconnected look up?
Answer Posted / 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 View All Answers
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is the difference between static cache and dynamic cache?
What is type 2 version dimension?
Where the applications and where ware house management system is used?
What is scd1 , scd2 , scd3?
Explain what is the advantages data mining over traditional approaches?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is crass reference table?
What is the main difference between schema in rdbms and schemas in datawarehouse?
How can you implement many relations in star schema model?
Explain what is the difference between power center & power mart?
Explain what is the difference between a primary and secondary actor in use case modeling?
What are different deliverables according to phases?
In microstrategy, how can we direct the sql generated to use a specifc table?
What are the types of dimensional modeling?