how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 35161 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
Why should you put your data warehouse on a different system than your oltp system?
What is data warehouse architecture?
What is Sequence clustering algorithm?
Explain when do we analyze the tables? How do we do it?
Can we start and stop single session in concurent bstch?
What is surrogate key? Where we use it explain with example?
What is a real-time data warehouse?
Explain what are fact, dimension, and measure?
Explain the versions of reportnet?
Can we take backup when the database is opened?
What is data mart in data warehouse?
Explain difference between view and materialized view?
What is the very basic difference between data warehouse and operational databases?
How to generate iqd file from framework manager?
What is the difference between a primary and secondary actor in use case modeling?
