[Solved] ROW_IS_CURRENT

[exhortae]

Hi,


Why do we need a ROW_IS_CURRENT column in a dimension.


Thanks.

[BoxesAndLines]

To easily identify the current row in a type 2 SCD.

[exhortae]

To easily identify the current row in a type 2 SCD.

For what purpose ?

* In a lookup to easily retrieve the primary key in a dimension ?
* When building reports ?
* ... ?

[TheNJDevil]

I think if you understood what a Type 2 SCD was in more detail, you would see the need for ROW_IS_CURRENT.

* In a lookup to easily retrieve the primary key in a dimension ? YES
* When building reports ? YES

Basically, anytime you need to separate the current record from the change record history.

[BoxesAndLines]

Assume I have a credit status code in my type 2 customer dimension. Now, tell me the current credit status of all customers.

Select * from customer_dim where current_row_ind = 'Y'

or

Select * from customer_dim where row_end_dt = '12/31/9999'

Two ways to skin the cat.

[exhortae]

Select * from customer_dim where row_end_dt = '12/31/9999'

I always used this one, I tought row_is_current might bring something else.

Thanks

[Sponsored content]