Explain the main differences between star and snowflake schema?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Warehouse General Interview Questions

What is data validation strategies for data mart v?

0 Answers  


Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

0 Answers  


Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---

1 Answers   Principal Finance, PT Metalogix Infolink Persada,


What is Snow Flake Schema design in database?

3 Answers  


What is data cleaning? How can we do that?

0 Answers  


What is your spectra photometer working principles?

0 Answers  


How to provide security in frame work manager for a query subject?

0 Answers  


What is Grain & Granularity in Data Warehouse.

2 Answers   TCS, TVS,


what are the similarities between ROLAP and MOLAP

2 Answers   Siemens,


Explain datawarehousing?

0 Answers  


Where the cache files stored?

0 Answers  


Which is the optimized method of extracting the data.

3 Answers  


Categories