Give the two types of tables involved in producing a star schema and the type of data they hold.
Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What are different types of Tables? 03.11.08
There are 4 types of tables in siebel 1) Base Table (Ex: s_contact, s_user) 2) Extension table ( Ex: s_contact_x) 3) EIM tables 4) Intersection...What Snow Flake Schema ? 25.09.08
Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. Fo...what is BUS Schema? 22.09.08
Bus Schema : Let we consider/explain these in x,y axis Dimension Table : A,B,C,D,E,F Fact Table: R,S...What is the difference between star schema and snow flake schema ?and when we use those schema’s? 20.09.08
Star Schema : Star Schema is a relational database schema for representing multimensional data. It is the simplest form of data warehouse schema that contains...Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true? 18.09.08
Star schema contains the dimesion tables mapped around one or more fact tables. It is a denormalised model.No need to use complicated joins.Queries results fas...Differences between star and snowflake schemas ? 18.09.08
Star schema A single fact table with N number of Dimension Snowflake schema Any dimensions with extended dimensions are know as snowflake schema star schema...What is “Extended Star Schema” and how did it emerge? 22.10.06
The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the char...What is ?Extended Star Schema? and how did it emerge? 30.07.06
The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the char...Differences between star and snowflake schemas? 17.03.06
Star schema - all dimensions will be linked directly with a fat table. Snow schema - dimensions maybe interlinked or may have one-to-many relationship with oth...Contrast DTDs versus XSDs. What are their similarities and differences? Which is preferred and why? 14.03.06
Document Type Definition (DTD) describes a model or set of rules for an XML document. XML Schema Definition (XSD) also describes the structure of an XML documen...