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
explain one complex mapping with logic? sales project?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain the types of transformations?
What is the benefit of partitioning a session?
What is the difference between router and filter?
What are the new features of informatica 9.x in developer level?
Can informatica load heterogeneous targets from heterogeneous sources?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to load last n records of file into target table - informatica
Explain the pipeline partition with real time example?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain pmcmd command usage in informatica
What is lookup transformation?
Partition, what happens if the specified key range is shorter and longer