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

View previous topic View next topic Go down

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

Post  VTK on 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

View user profile

Back to top Go down

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

Post  nick_white on 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 : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

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

Post  VTK on 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

View user profile

Back to top Go down

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

Post  BoxesAndLines on 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.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

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

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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