Interested to Buy Any Domain ? << Click Here >> for more details...
how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 37638 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
Answer Posted / dinesh
Two fact tables can connect thru constellation schema. It
is different from Star and snowflake schemas. In
constellation schema , we can join to fact tables
surrounded by dimensions.
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
How can you clear the cache?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Database in use is oracle?
Which columns go to the fact table and which columns go the dimension table?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Why should you put your data warehouse on a different system than your oltp system?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
How do you create surrogate key using ab initio?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain datawarehousing?
What is data validation strategies for data mart v?
Explain is olap databases are called decision support system true/false?
Fact table is in normalized or de-normalized form?
Code the tables statement for a single-level (most common) frequency?
What needs to be done when the database is shutdown?
