Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 87227 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 a repository? And how to add it in an informatica client?
r u done any partitions in ur project?
What is a stored procedure transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the difference between a connected look up and unconnected lookup?
update strategy transformation in informatica
what is the size of your data warehousing?
wat are deployement groups in informatica, how it will be used for developers
Is it possible to use a client with different version than that of its Informatica server?
What are ETL Tools?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
How to convert multiple rows to single row (multiple columns) in informatica
What is resilience time?
What is the difference between router and filter?
What is an expression transformation?
