Effectivity Satellites as Views

Data Vault 2.0
1

Hi,

I wonder if it’s okay (according to the DV2-Standard) to build Effectivity Satellites of Links as Views, when no business/effectivity dates are provided by the source system?

In this case, we’ll have to use the Vault’s load_datetime to build the timeline anyway. This means, the Effectivy Satellite would just carry “dead” (duplicated) information.

Hence my idea was to simply create a view like so:

create view silver_rv.s_customer_campaign as
select
	t.hk_customer_campaign,
	t.hk_customer,
	t.hk_campaign,
	t.load_ts,
	coalesce(lead(t.load_ts) over(partition by t.hk_customer order by t.load_ts) - interval '1 ms', to_timestamp('2099-12-31 23:59:59.999', 'yyyy-mm-dd hh24:mi:ss.fff')) as loadend_ts,
	t.record_source
from silver_rv.l_customer_campaign t
--where t.hk_customer = '\x0030b4079ebaa934aef727744a099578'

So far, this seems to work, but is it the preferred way?

I’m currently trying-out AutomateDV on a smal sample database and things work quite well.

Thanks,

Roger