how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 34681 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
Which component has onread method and what it is used for?
what are the different views that are considered when building an object-oriented software system?
Explain difference between snow flake and star schema.
How to performance tune reports?
Explain what are the advantages of query studio compared to report studio?
Can we start and stop single session in concurent bstch?
How can we load the time dimension?
Explain what is the data type of the surrogate key?
How can you set the session management?
Explain why denormalization is promoted in universe designing?
What is the function of etl when used in data warehousing?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What is a fact, dimension, measure?
Explain clustering algorithm?
What are the advantages of cold fusion?
