StackOverflow Questions for Tag: scd

Learner
Learner

Reputation: 1

How to implement SCD to update and maintain salary and dept of employee

Score: -1

Views: 96

Answers: 1

Read More
Filchos
Filchos

Reputation: 71

PostgreSQL: Foreign key to a table with SCD 2

Score: 0

Views: 210

Answers: 0

Read More
Gaurav Jan
Gaurav Jan

Reputation: 13

SCD TYPE 2 Implementation

Score: 0

Views: 352

Answers: 1

Read More
variable
variable

Reputation: 9694

What is the difference between storing the changing value in fact vs dimension?

Score: 1

Views: 171

Answers: 3

Read More
Shanmugavalli K
Shanmugavalli K

Reputation: 1

LM_36320 Session task instance [s_m_scdone]: Execution failed

Score: 0

Views: 622

Answers: 0

Read More
TrenT
TrenT

Reputation: 23

SQL INSERT, UPDATE and DELETE based on source table

Score: 2

Views: 532

Answers: 2

Read More
Kearon McNicol
Kearon McNicol

Reputation: 13

Azure Databricks Delta Live Table stored as SCD 2 is creating new records when no data changes

Score: 1

Views: 1188

Answers: 1

Read More
repcak
repcak

Reputation: 142

Delta live tables - Slowly changing dimensions

Score: 2

Views: 2609

Answers: 3

Read More
Kashyap
Kashyap

Reputation: 17466

Optimal query/join for joining scd-type-2 dimension with facts for reporting/aggregation

Score: 1

Views: 1200

Answers: 0

Read More
Rajib Deb
Rajib Deb

Reputation: 1774

SCD-2 using delta live table

Score: 2

Views: 424

Answers: 2

Read More
a.Smith
a.Smith

Reputation: 11

SQL SCD2 weekly statistic grouped by shipping date

Score: 0

Views: 132

Answers: 1

Read More
NathSQL
NathSQL

Reputation: 3

How to make non-sequential ranges unique?

Score: 0

Views: 126

Answers: 1

Read More
AMN
AMN

Reputation: 49

Delta Live Tables using SCD type 1

Score: 2

Views: 1060

Answers: 0

Read More
G0000000se
G0000000se

Reputation: 49

Handling invalid records in fact table after MERGE statement

Score: 1

Views: 47

Answers: 0

Read More
Vedant Desai
Vedant Desai

Reputation: 3

Can we get INSERT UPDATE Count from Slowly Changing Dimension Type-2 stored procedure?

Score: -2

Views: 429

Answers: 1

Read More
user3138594
user3138594

Reputation: 219

Changing the SQL generated by DBT

Score: 0

Views: 720

Answers: 1

Read More
Selim Bamri
Selim Bamri

Reputation: 23

SSIS Slowly changing dimension column

Score: 0

Views: 146

Answers: 0

Read More
Game Changers
Game Changers

Reputation: 13

How scdtype behaves when we have a new column added to the source table?

Score: 0

Views: 292

Answers: 0

Read More
rafamaniac
rafamaniac

Reputation: 57

SCD Start and End Date

Score: 0

Views: 892

Answers: 1

Read More
Rami Ouanes
Rami Ouanes

Reputation: 43

Converting EAVT table into SCD type 2

Score: 1

Views: 309

Answers: 1

Read More
PreviousPage 2Next