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 |
Explain vldb?
what is Materialized Views?
Explain what are slowly changing dimensions?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What we will do with the universe for faster process?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What is metadata in context of a datawarehouse?
What are the key columns in Fact and dimension tables?
What are the data marts?
Which is the optimized method of extracting the data.
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?
What are algorithms provided by Microsoft in SQL Server?