how can one connect two fact tables ? is it possible ? how?
- 8 Answers
- 34680 Views
- ABC, Oracle, Patni, I also Faced
- E-Mail Answers
Answer Posted / vams_gk
---------------------------------------------------
confrimed
[sales fact]<.........>[customer fact ]
| |
dimentions x,y,z dimentions a,b,c
-----------------------------------------------------
when u applied join between two fact tables u will get a
confriemd dimention
| Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
Explain what are the various file formats involved in reportnet?
What is the difference between view materialized view and view?
Explain what are the possible data marts in retail sales?
How can you set the session management?
Explain what is the difference between datawarehouse and bi?
What is the differences between star and snowflake schemas?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is degenerate dimension table?
What are the steps to build the datawarehouse?
Explain the structure of cold fusion?
can anybody mail me the FAQS for hyperion essbase amd planning
What is conformed fact?
Explain what is full load & incremental or refresh load?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
Explain the different types of data warehousing?
