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 what is the difference between stop and abort?
What is vdl (view definition language) explain?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Explain differences between star and snowflake schemas?
How do you define data block size?
What is the working process for application.cfm?
What is Sequence clustering algorithm?
What is type 2 version dimension?
Could any one explain me how to create cascading prompts?
Explain the different types of data warehousing?
What are the differences between datamart vs. Reporting cube?
What is perform recovery?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is hybrid slowly changing dimension?
Explain er diagram?