# \#effective\_from

**URL:** https://forum.data-community.org/tag/effective-from/4.md

[Latest](https://forum.data-community.org/latest.md) · [Categories](https://forum.data-community.org/categories.md) · [Tags](https://forum.data-community.org/tags.md)

---

## [Storing the start and end date for a link in effectivity satellite or "plain" satellite](https://forum.data-community.org/t/storing-the-start-and-end-date-for-a-link-in-effectivity-satellite-or-plain-satellite/949)

<div class="topic-metadata">

**Author:** [@cschwantes](https://forum.data-community.org/u/cschwantes)\
**Replies:** 4\
**Last updated:** [September 10, 2023, 1:04pm UTC](https://forum.data-community.org/t/storing-the-start-and-end-date-for-a-link-in-effectivity-satellite-or-plain-satellite/949 "2023-09-10T13:04:17Z")

</div>

I am currently modelling data vault 2.0 tables for one of our sources and I’m a bit stuck when it comes to handle validity dates. What the source delivers us, is the relationship between persons and certificates. Each p…

---

## [Using external load-dates](https://forum.data-community.org/t/using-external-load-dates/27)

<div class="topic-metadata">

**Author:** [@john.frost](https://forum.data-community.org/u/john.frost)\
**Replies:** 4\
**Last updated:** [January 28, 2022, 4:26pm UTC](https://forum.data-community.org/t/using-external-load-dates/27 "2022-01-28T16:26:28Z")

</div>

Hi all, I’m trying to load historical data in to a data vault warehouse, and we’re considering using a source-system effective-from date as a load date. How could I go about this without breaking the load patterns?