Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - What is Snowflake schema?

asked Rams August 31, 2014 12:48 PM  

What is Snowflake schema?


1 Answers

answered By vishnoiprem   0  
Star Schema
In star schema each dimension is represented with only one dimension table.
This dimension table contains the set of attributes.

There is a fact table at the centre. This fact table contains the keys to each of four dimensions.
The fact table also contain the attributes namely, dollars sold and units sold.
Note: Each dimension has only one dimension table and each table holds a set of attributes. For example the location dimension table contains the attribute set {location_key,street,city,province_or_state,country}. This constraint may cause data redundancy. For example the "Vancouver" and "Victoria" both cities are both in Canadian province of British Columbia. The entries
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  1 person following this tag

  Question tags

datastage × 4

Asked 4 years and 10 months ago ago
Number of Views -326
Number of Answers -1
Last updated
2 years and 1 month ago ago

  Similar questions

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!