Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37065 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is aggregate fact table?
What is surrogate key? Where we use it?
What is is a star schema?
Explain why dimenstion tables are denormalized in nature?
Explain datawarehousing?
Explain why should you put your data warehouse on a different system than your oltp system?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
Explain where do we use semi and non additive facts?
Compare aggregates and data marts
How to define a cube??
Explain the main difference between inmon and kimball philosophies of data warehousing?
Tell me what is degree of a relation?
What are the steps involved in creating dimensional modeling process?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
