Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37044 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 Operational Data Store?
What are the different methods of loading dimension tables?
What is the difference between junk dimension and degenerated dimension?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Why null values are mapped as 0 in fact tables?
What are data modeling and data mining?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is the difference between olap and oltp?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what is a cube in data warehousing concept?
What is real-time datawarehousing?
What is the differences between star and snowflake schemas?
How to load the time dimension?
Difference between e-r modeling and dimentional modeling?
Explain what is type 2 version dimension?
