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 are data modeling and data mining? Where it will be used?
What is many-to-many dimensional model in datawarehousing ?
What is perform recovery?
Why null values are mapped as 0 in fact tables?
What is your spectra photometer working principles?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is the use of incremental aggregation? Explain me in brief with an example?
explain about dirty dimension?
What is a full backup?
How to answer the question how many fakt table in your datawarehouse and what size it have?
Explain when do we analyze the tables? How do we do it?