4.Explain Snowflkeschema ?
Answer Posted / samir kumar sahoo
In snowflake schema the dimension table(denormalized table)
will be further divided into one or more dimentions
(normalized tables) to organize the infomation in a better
structural format.To design snowflake we should first
design star schema design.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is surrogate key? Explain with examples.
Start a batches with in a batch?
What are the different types of data warehousing?
What is a full backup?
Explain what is the metadata extension?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What are vaious etl tools in the market?
What needs to be done while starting the database?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are the steps involved in creating dimensional modeling process?
Explain the definition of normalized and denormalized view?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
The same tier?
Explain what is the difference between olap and datawarehosue?