What are the fundamental elements of the data warehouse?
No Answer is Posted For this Question
Be the First to Post Answer
What is data mart in data warehouse?
What is the difference between junk dimension and degenerated dimension?
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 parallel querys and query hints?
What is a cube in data warehousing concept?
where exactly in dataware house a confirmed dimension can be created
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
Explain the difference between view and materialized view?
Explain what is the difference between powerplay transformer and power play reports?
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?
What needs to be done while starting the database?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?