Question

Repeated PKs in Dimension Table - SSIS

score 14 · Answer 1 · 2023-08-29T15:01:34.340000

14

Views

Repeated PKs in Dimension Table - SSIS

Published on 29 August 2023 at 15:01

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

214

Views

PostgreSQL as OLAP setup

Published on 29 August 2023 at 04:25

score 134 · Answer 3 · 2023-08-15T19:00:19.050000

134

Views

SCD TYPE 2 Implementation

Published on 15 August 2023 at 19:00

score 35 · Answer 4 · 2023-08-04T18:14:26.827000

35

Views

How to import datawarehouse to excel without using odbc?

Published on 04 August 2023 at 18:14

score 381 · Answer 5 · 2023-07-03T07:20:56.007000

381

Views

Azure Synapse Analytics - Dedicated Pool - Create user - Incorrect syntax near 'PASSWORD'

Published on 03 July 2023 at 07:20

score 455 · Answer 6 · 2023-06-15T04:55:40.860000

455

Views

How to set default time zone for SQL Warehouse in Databricks?

Published on 15 June 2023 at 04:55

score 18 · Answer 7 · 2023-06-11T14:25:52.573000

I am using SSIS Vs to populate my fact table from staging to data warehouse but it is showing an error to the OLEDB destinations

score 216 · Answer 8 · 2023-01-17T07:56:32.517000

216

Views

Invoice header and invoice line fact table extraction question

Published on 17 January 2023 at 07:56

score 672 · Answer 9 · 2022-12-28T08:16:08.127000

672

Views

SSAS "The Subscription identifier is invalid"

Published on 28 December 2022 at 08:16

score 107 · Answer 10 · 2022-08-30T14:27:28.823000

107

Views

Generate a number for a combination of columns in SQL Server

Published on 30 August 2022 at 14:27

score 139 · Answer 11 · 2022-08-14T17:41:17.023000

139

Views

Querying a Galaxy Schema in data warehouse

Published on 14 August 2022 at 17:41

score 111 · Answer 12 · 2022-08-11T10:41:47.133000

111

Views

Can we use spark.sql on any other database tables other than Hive tables?

Published on 11 August 2022 at 10:41

score 241 · Answer 13 · 2022-08-03T08:53:58.027000

241

Views

Dimensions inside FACT table?

Published on 03 August 2022 at 08:53

score 81 · Answer 14 · 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 428 · Answer 15 · 2022-05-16T10:09:54.930000

428

Views

How to add a column based on the table which the data come from in SSIS?

Published on 16 May 2022 at 10:09

score 163 · Answer 16 · 2022-05-12T18:06:32.117000

163

Views

Data warehouse design for parking lot - date and time dimensions

Published on 12 May 2022 at 18:06

score 215 · Answer 17 · 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 421 · Answer 18 · 2022-03-10T16:05:26.233000

421

Views

Filter overlapping date ranges with latest "Valid from" date

Published on 10 March 2022 at 16:05

score 120 · Answer 19 · 2022-03-01T19:48:24.917000

120

Views

Optimize a Group By that is done on a joined table in Azure SQL Data Warehouse

Published on 01 March 2022 at 19:48

score 426 · Answer 20 · 2022-01-30T05:24:55.597000

426

Views

Why can't we use data warehouse directly instead of database?

Published on 30 January 2022 at 05:24

List Question

Repeated PKs in Dimension Table - SSIS

PostgreSQL as OLAP setup

SCD TYPE 2 Implementation

How to import datawarehouse to excel without using odbc?

Azure Synapse Analytics - Dedicated Pool - Create user - Incorrect syntax near 'PASSWORD'

How to set default time zone for SQL Warehouse in Databricks?

I am using SSIS Vs to populate my fact table from staging to data warehouse but it is showing an error to the OLEDB destinations

Invoice header and invoice line fact table extraction question

SSAS "The Subscription identifier is invalid"

Generate a number for a combination of columns in SQL Server

Querying a Galaxy Schema in data warehouse

Can we use spark.sql on any other database tables other than Hive tables?

Dimensions inside FACT table?

Many-to-many from relational design to dimensional design

How to add a column based on the table which the data come from in SSIS?

Data warehouse design for parking lot - date and time dimensions

How to fit a separate table in data warehouse model?

Filter overlapping date ranges with latest "Valid from" date

Optimize a Group By that is done on a joined table in Azure SQL Data Warehouse

Why can't we use data warehouse directly instead of database?

Trending Questions

Popular # Hahtags

Popular Questions