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

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 ?

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

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.

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.