Explain the definition of normalized and denormalized view and what are the differences between them?
867What are situations where snow flake schema is better than star schema to use and when the opposite is true?
932Post New Data Warehouse General Questions
Explain why are oltp database designs not generally a good idea for a data warehouse?
Explain the main difference between inmon and kimball philosophies of data warehousing?
How to handle multi value dimensions?
How can we run the graph? What is the procedure for that?
Explain about core dimension,
What is aggregate fact table?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What is the data type of the surrogate key?
Where the applications and where
What needs to be done when the database is shutdown?
What is data analytics in simple terms?
What are the possible data marts in retail sales?
Explain Association algorithm in Data mining?
What is the difference between connected and unconnected stored procedures?
Explain can report net connect multiple datasource at a time in report creation time?