Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 87654 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / mallikarjun
There are 3 types of Schemas,
1.Star Schema
2.Snowflake Schema
3.Galaxy/Integrated/Hybride/Consalation Schemas
1)Star Schema-It is defined as the fact table is centrally located,surrounded by dimension tables is called star schema.In that dimension tables are denormalized and fact table is normalized.(or)Star schema is defind as two or more fact and two or more dimension tables that are related to foreigh keys.
2)Snowflake Schema-It is defind as the Denormalized Dimensions tables are can be splited into two or more normalized dimensions is called snowflake schema.In that both dimensions and fact tables are normalized.
3)Hybride Schema-It is defind as a dimension table is shared by two or more fact tables.
| Is This Answer Correct ? | 26 Yes | 9 No |
Post New Answer View All Answers
What is confirmed fact in dataware housing?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the reusable transformations?
What is the meaning of decode in informatica?
What is meant by active and passive transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain why we use partitioning the session in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What does command task mean?
explain abt ur project architecture?
What is incremental aggregation?
How to update a particular record in target with out running whole workflow?
what is the size of u r source(like file or table)?
What is an Integration service in Informatica?
Target increases every day even though no new record was inserted
