What are the differences between star and snowflake schema?
No Answer is Posted For this Question
Be the First to Post Answer
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain what is cost benefit analysis (cba)?
Which component has onread method and what it is used for?
Explain difference between e-r modeling and dimentional modeling?
what is Materialized Views?
What is the difference between a W/H and an OLTP application?
How to test report in reportnet?
What is drill-through?
What are partition points?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Can a dimension table contain numeric values?