Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 87259 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / thirumalai
There are 3 types of Schemas :
1. Star Schema -The star schema architecture is the
simplest data warehouse schema. It is called a star schema
because the diagram resembles a star, with points radiating
from a center. The center of the star consists of fact
table and the points of the star are the dimension tables.
Usually the fact tables in a star schema are in third
normal form(3NF) whereas dimensional tables are de-
normalized. Despite the fact that the star schema is the
simplest architecture
2. Snow Flake Schema - The snowflake schema architecture is
a more complex variation of the star schema used in a data
warehouse, because the tables which describe the dimensions
are normalized
3. Fact Constallation Schema : For each star schema it is
possible to construct fact constellation schema(for example
by splitting the original star schema into more star
schemes each of them describes facts on another level of
dimension hierarchies). The fact constellation architecture
contains multiple fact tables that share many dimension
tables.
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
What are the differences between joiner transformation and source qualifier transformation?
which one is better performance wise joiner or look up
How would you join a node to the already existing domain?
To import the flat file definition into the designer where should the flat file be placed?
How to extract the informatica rejected data?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to differentiate between the active and passive transformations?
draw informatica architecture 8.6 ?
What are the modules in Power Center
Partition, what happens if the specified key range is shorter and longer
What does role playing dimension mean?
How to configure mapping in informatica?
What is dimensional table? Explain the different dimensions.
Explain sessions?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
