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 |
Compare and contrast aggregates & indexes
Explain the definition of normalized and denormalized view?
Explain what are components of report studio?
How are models actually derived?
what type of raid setup would you put your tx logs?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Which kind of index is preferred in DWH?
What is the purpose of Dataware Control?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain normalization?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What according to you might be the future of data warehousing?