Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Deletes in the source system for Type-2...

3 posters

Go down

Deletes in the source system for Type-2... Empty Deletes in the source system for Type-2...

Post  VTK Wed Feb 04, 2015 6:25 pm

Whats the standard practice for deletes in the source system for Current Row Identifier ?
I usually do 'N' for 'Current Row Identifier' but people argue that we should put Y in there as that's the most recent version for that entity. To me, it's not current active version.

Thoughts ?

VTK

Posts : 50
Join date : 2011-07-15

Back to top Go down

Deletes in the source system for Type-2... Empty Re: Deletes in the source system for Type-2...

Post  nick_white Thu Feb 05, 2015 3:18 am

That field in an SCD2 Dim is there to indicate which is the most recent row from an SCD perspective, it has nothing to do with the real-world status of the record - so if it is the most recent record then set it to Y. The record status (Active, Deleted, Prospect or whatever) would be held in a status field

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

Deletes in the source system for Type-2... Empty Re: Deletes in the source system for Type-2...

Post  VTK Thu Feb 05, 2015 10:34 am

It's not actually a dim table but It's kind of a staging area where we keep versions of our source system tables which in this case happend to be mainframe VSAM files...I can see the validity of the argument though.

VTK

Posts : 50
Join date : 2011-07-15

Back to top Go down

Deletes in the source system for Type-2... Empty Re: Deletes in the source system for Type-2...

Post  BoxesAndLines Thu Feb 05, 2015 8:29 pm

A current row indicator set to Y with an end date populated is often used to show that the row was deleted in the source. It's better to have business dates or statuses like Nick recommended but as often is the case, that the data is not available.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Deletes in the source system for Type-2... Empty Re: Deletes in the source system for Type-2...

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum