What are the different types of schemas?
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 is status code in informatica?
When do you use sql override in a lookup transformation?
How can repository reports be accessed without sql or other transformations?
What is a joiner transformation and why it is an active one?
What is the function of look up transformation?
What do you mean by worklet?
How can we improve session performance in aggregator transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Can informatica load heterogeneous targets from heterogeneous sources?
What is event and what are the tasks related to it?
What do you mean incremental aggregation?
What is informatica? Why do we need it?
How we can create indexes after completing the loan process?
What are the transformations that are not supported in mapplet?
What is powercenter on grid?