topic Re: SCD Type2 in SAS Studio

SCD Type2

laxmanpai — Wed, 29 Jan 2020 05:40:07 GMT

Hi,

How do we keep only the active records using SCD Type2 in every run ?.

Eg : I execute the job today using SCD type 2 and load into the target table.

Tomorrow when I rerun the same job, I should have only the current active records excluding the others. Is there any changes that can be done in SCD type 2 transformation ?

Re: SCD Type2

laxmanpai — Tue, 04 Feb 2020 06:02:12 GMT

I have not recieved any reply

Re: SCD Type2

jennifert — Tue, 04 Feb 2020 18:40:57 GMT

Hi @laxmanpai ,

Is this maybe a question for the SAS Data Management community rather than SAS Studio?

thanks,

Jennifer

Re: SCD Type2

Patrick — Wed, 05 Feb 2020 10:18:06 GMT

@laxmanpai wrote:

Hi,

How do we keep only the active records using SCD Type2 in every run ?.

Eg : I execute the job today using SCD type 2 and load into the target table.

Tomorrow when I rerun the same job, I should have only the current active records excluding the others. Is there any changes that can be done in SCD type 2 transformation ?

To get answers faster ask DIS questions in the Data Management Forum.

As for your question: Type 2 tables keep the full change history so you won't get rid of old records but you expire them. If you want to maintain such a table then yes, the SCD Type 2 transformation can help you with this.

If you always have a full load from source (not deltas) then there is an option somewhere which let's you choose something like "close out records in target but not in source".

Re: SCD Type2

Patrick — Wed, 12 Feb 2020 05:05:45 GMT

@laxmanpai

You haven't provided any feedback. Is your question answered?