Questions about star-schema
Read more about star-schema
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
What is the difference between storing the changing value in fact vs dimension?
I have customer dimension table and the location of customer can change.
The customerid filters the sales fact table.
I have 2 options:
Slowly changing dimension type 2 to hold 1 new record for each ...
variable
Votes: 0
Answers: 3
Whether sales (fact) table should be made to have the userid from customer (dim) table in dimensional modeling?
I have following relationships:
User (userid, username)
Customer (customerid, userid, customername)
Sales (salesid, customerid, saledate, saleamt)
In the DW I am loading the data as follows:
User (use...
variable
Votes: 0
Answers: 1
How to auto-increment in posgresql?
i have a star schema datawarehouse i did the load with python and i set the id of the employee = id in the database , ron has id number = 99 , Tom =201 ,Alice =87 but in the database i found the id wh...
Smordy
Votes: 0
Answers: 1