how can one connect two fact tables ? is it possible ? how?
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
What is bi?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain bus schema?
Explain what is the difference between stop and abort?
What is meant by metadata in context of a data warehouse and how it is important?
How can we load the time dimension?
Why we use repository connectivity?
What are the stages that are required in data warehousing?
What is difference macros and prompts?
What are universe requirements?
What is application.cfm?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain what is ods (operation data source)?
What are the different types of scd's used in data warehousing?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar