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?
528Post New Data Warehouse General Questions
Explain what are components of reportnet?
What is defined as partial backup?
What is fact less fact table? Where you have used it in your project?
Explain what is metadata reporter?
What is degenerate dimension table?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What is static and local variable?
How to create context?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Tell me what is degree of a relation?
Define Data Warehousing?
Explain what are non-additive facts?
Explain what is the difference between view filter and report filter?
What is perform recovery?
Explain the hierarchies level data warehousing.