What are the different types of schemas?
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 decode in static cache?
What is meant by query override?
Informatica settings are available in which file?
Why do you use Mapping Parameter and mapping variable?
What is pmcmd command?
if we have a delimiters at unwanted places in a flat file how can we over come those.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
can you please explain me pre session and post session options?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is meant by LDAP users?
How do we call shell scripts from informatica?
Clarify the utilization of aggregator cache record?
On which transformations you created partitions in your project?
Where is metadata stored?
Explain the types of transformations?