how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 34672 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
Answer Posted / mallika
We can connect two fact tables by using constellation
schema or galaxy schema.
we have 3 types of schemas
star
snowflake
constellation or galaxy
in star schema we have data redundancy.we do not normalize
dimension tables.
in snowflake we normalize dimension tables to reduce space
boyh star aand snowflake we use only one fact and many
dimesion tables.in some situations we have to use more than
one fact table then we use constellation.but its vary
rarely used
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What is the difference between mapping parameter & mapping variable in data warehousing?
What are the data marts?
What is data analysis?
What is the use of incremental aggregation? Explain me in brief with an example?
What are the steps to build the datawarehouse?
What are the reasons to use a chameleon method in data warehousing?
Where the applications and where ware house management system is used?
For faster process, what we will do with the universe?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What is a relationship?
What is a staging area? Do we need it? What is the purpose of a staging area?
I need to set predefined condition. How I do this?
I have two universes created by two difference database can we join them in designer & report level? How
