Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37430 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 olap and oltp?
what is user variable in affinium campaign? and some real time examples.
How to pivot data using informatica when you have variable amount of pivot rows?
Explain what is partitioning? What are the types of partitioning?
Explain a mapping, session, worklet, workflow, mapplet?
What is the difference between data warehouse and operational systems?
What needs to be done while starting the database?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain what are the advantages of query studio compared to report studio?
Explain what is power center repository?
What does level of granularity of a fact table signify?
What is aggregate fact table?
How to create diff. Types of templates?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain normalization?
