Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37403 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 are the steps involved in creating dimensional modeling process?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
what is user variable in affinium campaign? and some real time examples.
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is the goal of optimizer?
Explain can a dimension table contains numeric values?
What is surrogate key? Where we use it explain with example?
What is crass reference table?
What is the difference between junk dimension and degenerated dimension?
What are universe requirements?
What is a staging area? Do we need it? What is the purpose of a staging area?
What are Aggregate tables?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain a relation schema and a relation?
What is the function of etl when used in data warehousing?
