What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
No Answer is Posted For this Question
Be the First to Post Answer
What needs to be done when the database is shutdown?
Explain dimensional modelling?
How many project sources we can create in metadata?
what is hybrid schema
Explain what is the metadata extension?
How to limit the max no of rows retrieved in the report?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What are components of reportnet?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
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?
What is application.cfm?
Explain the difference between data ware house & data mart?