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
What are the various transformation available?
What are components of report studio?
Explain how many ways you create ports?
Explain the data type of the surrogate key?
Explain what is power center repository?
What is the difference between er modeling and dimensional modeling?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is recovering sessions?
Explain hybrid slowly changing dimension?
What is the difference between junk dimension and degenerated dimension?
What is the purpose of Dataware Control?
What should I have in mind when building olap solution from scratch?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is freehand sql?
What are the different ways to represent the loading of dimension tables?