Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 87193 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
Explain the informatica workflow?
Explain how many types of dimensions are available in informatica?
Explain in detail about scd type 1 through mapping.
In informatics server which files are created during the session rums?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
When do you use sql override in a lookup transformation?
Explain why we use partitioning the session in informatica?
COM components can be used in Informatica
Define the various join types of joiner transformation?
What are Dimensional table?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the mapping parameters and mapping variables?
What is the need of an ETL tool?
What do you mean by blocking transformation?
Explain the scenario which compels informatica server to reject files?
