Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between a connected look up and
unconnected look up?
- 1 Answers
- 6675 Views
- I also Faced
- E-Mail Answers
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 the data type of the surrogate key?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is a functional dependency f said to be minimal?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is Analysis Services?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is the use of incremental aggregation? Explain me in brief with an example?
What is load manager?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What is the difference between data warehouse and operational systems?
Which component has onread method and what it is used for?
Why null values are mapped as 0 in fact tables?
What is loop in data warehousing?
Explain what are slowly changing dimensions?
Fact table is in normalized or de-normalized form?
