how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 35159 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
Where do we use semi and non additive facts?
What is fact less fact table? Where you have used it in your project?
What is the purpose of Dataware Control?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What is data stream and data adaopter. Is it same are different? Explain?
How much data hold in one universe.
Explain why should you put your data warehouse on a different system than your oltp system?
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?
What is Analysis Services?
What are the difference between snow flake and star schema?
What is crass reference table?
Explain what are components of reportnet?
What are session timeout and application timeout?
Define Data Warehousing?
Explain what are the advantages of query studio compared to report studio?
