Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37454 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thammera
This confirm dimenstion methodology.If a dimension table is
connected to more then one Fact table is called confirm
dimension.
| Is This Answer Correct ? | 32 Yes | 5 No |
Answer / raj
Fact Tables are connected by confirmed dimensions, Fact
tables cannot be connected directly, so means of dimension
we can connect
| Is This Answer Correct ? | 12 Yes | 8 No |
Answer / dinesh
Two fact tables can connect thru constellation schema. It
is different from Star and snowflake schemas. In
constellation schema , we can join to fact tables
surrounded by dimensions.
| Is This Answer Correct ? | 9 Yes | 6 No |
Answer / itesh
Yes it’s possible,
Since after all its a table, if you have the proper
relationship no problem,
Conceptually it’s correct to have a have confirmed
dimension but it can be manipulated,
Ex.
I have one fact a table FACT EOD this year i have joined
with EOD FACT Last year with time id .its working fine
Again
If you have two fact table A and B then create a derived
table from B Of the required key and measure only and join
with original fact table A ,
Better check with a sql query.
Nothing is impossible……
Cheers
I
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
Answer / 9885657928
Ya it is possible to connect the two fact tables By using
Schemas.
Eg:Hybrid schema or Gelaxy schema
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / vams_gk
---------------------------------------------------
confrimed
[sales fact]<.........>[customer fact ]
| |
dimentions x,y,z dimentions a,b,c
-----------------------------------------------------
when u applied join between two fact tables u will get a
confriemd dimention
| Is This Answer Correct ? | 3 Yes | 9 No |
Answer / nethaji
Yes,We can connect two fact tables by using confirmed
dimension indirectly or directly by confirmed fact.Here when
a fact appears in more than one fact table we can join using
this fact.
eg:
fact table 1 fact table 2
------------ ------------
measures maesures
revenue <=======> revenue
| Is This Answer Correct ? | 5 Yes | 12 No |
Name a few sectors which use data warehousing?
Explain what are the different types of join operations?
Explain the data type of the surrogate key?
Where the applications and where ware house management system is used?
What is scd1 , scd2 , scd3?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain is fact table?
What should I have in mind when building olap solution from scratch?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is meant by metadata in context of a data warehouse?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
Teradata 
