python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - datamart

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...
test-img

ssaf

data-warehouse

snowflake-schema

star-schema

fact-table

datamart

Votes: 0

Answers: 1

Latest Answer

Snowflake describes one or more objects in your model. So some parts of your model could be snowflaked and others not Datamarts are logical groupings of your facts and dimensions, not physical ones....
test-img

NickW

Posts

Questions

Blogs

Jobs