python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How different fact tables are handled to share some common dimension tables in data marts in star model?
I am quite new to DW and I am just learning the stuff. I read on the Internet that after the ETL process, DW data is then stored in some data marts for some reasons such as ease of use. Each data mart...
ssaf
Votes: 0
Answers: 1
In this specific example, can I have more than one fact table?
I have the following assignment for Business Intelligence Class:
"The CSUF Business Association is conducting a babysitter service as a fundraiser
for different clubs in college. When a customer...
user17510097
Votes: 0
Answers: 1
How to populate fact table with Surrogate keys from dimensions?
Could someone please help me understand how to populate the fact table with Surrogate keys from dimensions using SSIS?
I load my dimension tables and assign for each a surrogate key. I want to add the...
chaneb
Votes: 0
Answers: 1