Clear all

Temporal Data

Posts: 0
Topic starter
Joined: 52 years ago


Can you please enlighten what should be done incase we have some "Customer Status Code" with a date set in future (Valid From is in future). For Example Table Customer and Child Table Customer Status



How can we model this in a customer Status Satellite? Here if you notice, on 05.03.2019, we recieve 2 Status Codes for the Customer. One is active instantly (Status C) but the other is active as of 01.09.2019 (D). How should we solve it?

What is a typical bitemporal sat load pattern?


10 Replies