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 are the different ways to implement parallel processing in informatica?
What is resilience time?
explain about unit testing? in real time?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Clarify the utilization of aggregator cache record?
How union transformation is used?
What is enterprise data warehousing?
What is the function of union transformation?
How to configure mapping in informatica?
What is an expression transformation in informatica?
What is the function of aggregator transformation?
Can you use flat files in Mapplets.
whats the logic to load the lower level of granularity of data to fact table.
Explain the mapping variable usage example in informatica
What is status code in informatica?