Differentiation between star and snowflake schemas
Briefly describe the differentiation between star and snowflake schemas?
Expert
Star schema : A highly de-normalized method. A star schema has one fact table and is related with frequent dimensions table and depicts a star.
Snow flake schema : The normalized principles applied star schema is named as Snow flake schema. Each and Every dimension table is related with sub dimension table. Differences :
A dimension table will not have parent table in star schema, while snow flake schemas have one or further parent tables.
The dimensional table itself comprises of hierarchies of dimensions in star schema, while hierarchies are divide in various tables in snow flake schema. The drilling down data from top mainly hierarchies to the lowermost hierarchies can be done.
hatcher also created the accompanying Level 1 data flow diagram for this process. Unfortunately, this DFD has numerous syntax and semantic errors. Identify the errors. Redraw the DFD to more correctly represent the receive supplier shipments process.
Explain the term Vdisk and how this will communicate along with physical data storage at the time of data retrieval by AMP?
Describe the differences between unstructured data and structured data?
What are the drawbacks of the client or server model?
Explain the term queue in data structure? Answer: In data structure a queue is a sequential organization of data. It is a first in first out i.e. FIFO type of data s
Define the term filter?
Why is the multi value or multicolumn problem any other type of the multivalued dependency problem?
Explain the drill mode?
What are the kinds of files employed in Oracle recovery?
Explain and compare a procedure and a trigger?
18,76,764
1959105 Asked
3,689
Active Tutors
1444006
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!