Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37641 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 a fact, dimension, measure?
What is a hash cluster?
Where we use surrogate key explain with example?
What is operational data store (ods)?
What is surrogate key? Where we use it explain with example?
Can you pass sql queries in filter transformation?
Why is chameleon method used in data warehouse?
What are the reasons to use a chameleon method in data warehousing?
Explain how to generate iqd file from framework manager?
Can we start and stop single session in concurent bstch?
What is the data type of the surrogate key?
How many project sources we can create in metadata?
What are the various transformation available?
What are the mapping paramaters and maping variables?
Compare aggregates and data marts
