TechQA.

Question

Model the number of available spots in dimension or fact table?

score 56 · Answer 1 · 2024-03-05T15:14:11.860000

0

Answer

56

Views

Model the number of available spots in dimension or fact table?

56 views Asked by JessiSexy At 05 March 2024 at 15:14

score 83 · Answer 2 · 2024-02-02T00:31:29.040000

Using stereotypes to enhance dimensional modelling

83 views Asked by Nick.Mc At 02 February 2024 at 00:31

score 242 · Answer 3 · 2023-06-21T13:05:42.497000

Calendar Dimension in Datawarehouse Modeling

242 views Asked by userrr At 21 June 2023 at 13:05

score 297 · Answer 4 · 2023-06-02T11:04:02.023000

Oracle partition / archive strategy for type 2 dimension table

297 views Asked by Reindeer At 02 June 2023 at 11:04

score 97 · Answer 5 · 2023-02-02T12:42:28.990000

How to deal with numeric attribute in dimension?

97 views Asked by Chicago1988 At 02 February 2023 at 12:42

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

Bridge table for many-to-many relationship

483 views Asked by Daniel At 29 November 2022 at 18:53

score 439 · Answer 7 · 2022-10-18T07:38:12.703000

Can a Dimension Table contain Multiple Data Sets

439 views Asked by LordRofticus At 18 October 2022 at 07:38

score 107 · Answer 8 · 2022-09-02T14:21:40.017000

Model scd by using role-playing?

107 views Asked by Chicago1988 At 02 September 2022 at 14:21

score 168 · Answer 9 · 2022-08-03T16:42:46.827000

Modelling customer onboarding in fact or dimension table?

168 views Asked by josescuderoh At 03 August 2022 at 16:42

score 299 · Answer 10 · 2022-06-09T06:04:34.527000

Data warehousing relation between 2 fact tables with different grain for drill down in report tool?

299 views Asked by Jayrune At 09 June 2022 at 06:04

score 609 · Answer 11 · 2022-03-08T21:19:39.143000

Star schema - splitting dimensions into multiple smaller dimensions

609 views Asked by user3195568 At 08 March 2022 at 21:19

score 136 · Answer 12 · 2022-02-14T11:29:16.483000

Not sure whether to model Tickets as a Fact or Dimension

136 views Asked by Bart Jonk At 14 February 2022 at 11:29

score 1164 · Answer 13 · 2021-10-16T13:18:53.780000

Joining date dimension multiple times? - Kimball's book on Data warehouse and Dimension Modeling

1.1k views Asked by SabUrb At 16 October 2021 at 13:18

score 202 · Answer 14 · 2021-10-08T11:27:13.377000

When to rename Date foreign keys?

202 views Asked by Peterson Davis At 08 October 2021 at 11:27

score 467 · Answer 15 · 2021-06-26T22:04:11.537000

Is AdventureworksDW's FactInternetSales an accumulating snapshot table?

467 views Asked by Pblade At 26 June 2021 at 22:04

score 1218 · Answer 16 · 2021-05-14T13:04:52.750000

What should update when an SCD1 change happens on an SCD2 aware table

1.2k views Asked by Ralf At 14 May 2021 at 13:04

score 258 · Answer 17 · 2021-05-10T11:32:20.723000

Combining additive and semi-additive facts in a single report

258 views Asked by Anton At 10 May 2021 at 11:32

score 454 · Answer 18 · 2021-04-25T19:05:36.877000

SQL - load data warehouse dimension table without business IDs?

454 views Asked by jd0963 At 25 April 2021 at 19:05

score 785 · Answer 19 · 2021-04-24T03:21:41.463000

Dimension model (recursive / hierarchical) for Data Warehouse

785 views Asked by zysirhc At 24 April 2021 at 03:21

score 143 · Answer 20 · 2021-04-23T08:42:22.790000

Investment Valuation Data Model Design Issue

143 views Asked by user15746219 At 23 April 2021 at 08:42

TechQA.

List Question

Model the number of available spots in dimension or fact table?

Using stereotypes to enhance dimensional modelling

Calendar Dimension in Datawarehouse Modeling

Oracle partition / archive strategy for type 2 dimension table

How to deal with numeric attribute in dimension?

Bridge table for many-to-many relationship

Can a Dimension Table contain Multiple Data Sets

Model scd by using role-playing?

Modelling customer onboarding in fact or dimension table?

Data warehousing relation between 2 fact tables with different grain for drill down in report tool?

Star schema - splitting dimensions into multiple smaller dimensions

Not sure whether to model Tickets as a Fact or Dimension

Joining date dimension multiple times? - Kimball's book on Data warehouse and Dimension Modeling

When to rename Date foreign keys?

Is AdventureworksDW's FactInternetSales an accumulating snapshot table?

What should update when an SCD1 change happens on an SCD2 aware table

Combining additive and semi-additive facts in a single report

SQL - load data warehouse dimension table without business IDs?

Dimension model (recursive / hierarchical) for Data Warehouse

Investment Valuation Data Model Design Issue

Popular Questions

Trending Questions