Question

INSERT a single row in fact table

score 104 · Answer 1 · 2023-11-15T22:16:54.790000

104

Views

INSERT a single row in fact table

Published on 15 November 2023 at 22:16

score 60 · Answer 2 · 2023-09-18T05:35:12.400000

60

Views

How to deal with multiple facts in dimensional modelling

Published on 18 September 2023 at 05:35

score 214 · Answer 3 · 2023-08-29T04:25:24.320000

214

Views

PostgreSQL as OLAP setup

Published on 29 August 2023 at 04:25

score 67 · Answer 4 · 2023-03-14T14:53:07.727000

67

Views

PostgreSQL ON CONFLICT add new entry with new timestamp

Published on 14 March 2023 at 14:53

score 483 · Answer 5 · 2022-11-29T18:53:22.203000

483

Views

Bridge table for many-to-many relationship

Published on 29 November 2022 at 18:53

score 100 · Answer 6 · 2022-11-01T10:03:52.470000

100

Views

Stream data into BigQuery data mart with three different dataflow jobs, get correct surrogate key for the fact table from dimensional tables

Published on 01 November 2022 at 10:03

score 181 · Answer 7 · 2022-10-18T16:54:12.967000

181

Views

Data warehouse modling - to use ID or text in a dimensional table

Published on 18 October 2022 at 16:54

score 63 · Answer 8 · 2022-10-05T13:56:36.997000

63

Views

Dimension Fact tables issue

Published on 05 October 2022 at 13:56

score 287 · Answer 9 · 2022-07-30T12:45:58.883000

287

Views

Advice on basic star-schema design (Date dimension)

Published on 30 July 2022 at 12:45

score 1k · Answer 10 · 2022-07-25T07:15:02.930000

1k

Views

How to join dimension tables while populating a fact table if business key of one dimension table is not in the other joining table?

Published on 25 July 2022 at 07:15

score 81 · Answer 11 · 2022-06-16T01:24:11.480000

81

Views

Many-to-many from relational design to dimensional design

Published on 16 June 2022 at 01:24

score 215 · Answer 12 · 2022-04-10T05:03:46.503000

215

Views

How to fit a separate table in data warehouse model?

Published on 10 April 2022 at 05:03

score 86 · Answer 13 · 2022-03-23T12:43:29.393000

86

Views

Whether sales (fact) table should be made to have the userid from customer (dim) table in dimensional modeling?

Published on 23 March 2022 at 12:43

score 845 · Answer 14 · 2022-01-13T10:42:59.243000

845

Views

Should I use multiple fact tables for each grain or just aggregate from lowest grain?

Published on 13 January 2022 at 10:42

score 78 · Answer 15 · 2021-11-23T19:58:32.097000

78

Views

Designing a DW Model Diagram

Published on 23 November 2021 at 19:58

score 402 · Answer 16 · 2021-11-21T23:04:13.357000

402

Views

How to handle Manual Input within your Data Warehouse

Published on 21 November 2021 at 23:04

score 217 · Answer 17 · 2021-11-15T07:54:00.817000

217

Views

Multiple sources for dimensions in Data Warehouse

Published on 15 November 2021 at 07:54

score 537 · Answer 18 · 2021-11-07T15:07:28.567000

537

Views

What normal form is a Star schema model in Data Warehouse

Published on 07 November 2021 at 15:07

score 164 · Answer 19 · 2021-09-20T13:31:49.447000

164

Views

Star schema for tables with overlap periods

Published on 20 September 2021 at 13:31

score 119 · Answer 20 · 2021-08-13T06:09:38.520000

119

Views

How can I make sure every change to dimension is captured in SCD2?

Published on 13 August 2021 at 06:09

List Question

INSERT a single row in fact table

How to deal with multiple facts in dimensional modelling

PostgreSQL as OLAP setup

PostgreSQL ON CONFLICT add new entry with new timestamp

Bridge table for many-to-many relationship

Stream data into BigQuery data mart with three different dataflow jobs, get correct surrogate key for the fact table from dimensional tables

Data warehouse modling - to use ID or text in a dimensional table

Dimension Fact tables issue

Advice on basic star-schema design (Date dimension)

How to join dimension tables while populating a fact table if business key of one dimension table is not in the other joining table?

Many-to-many from relational design to dimensional design

How to fit a separate table in data warehouse model?

Whether sales (fact) table should be made to have the userid from customer (dim) table in dimensional modeling?

Should I use multiple fact tables for each grain or just aggregate from lowest grain?

Designing a DW Model Diagram

How to handle Manual Input within your Data Warehouse

Multiple sources for dimensions in Data Warehouse

What normal form is a Star schema model in Data Warehouse

Star schema for tables with overlap periods

How can I make sure every change to dimension is captured in SCD2?

Trending Questions

Popular # Hahtags

Popular Questions