Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 86628 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
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the Process to creating lookup transformation in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Enlist some properties of sessions.
Mention some types of transformation?
can you please explain me pre session and post session options?
What is the difference between router and filter?
EXL informatica Questions
what is the -ve test case in your project.
How can you validate all mappings in the repository simultaneously?
Differentiate between reusable transformation and mapplet.
What is a stored procedure transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What you know about transaction control transformation?
