You might have already had to deal with getting the load to satellite tables correct. The data vault test suite is designed to keep your data vault loading patterns honest. Going further from this idea, this post will provide a case study on what can go wrong when you don’t follow this loader rule.
1: Ensure you are comparing against current records for satellite loads.
Day 1 staged content:
Press enter or click to view image in full size
Day 1 satellite after staged content has been loaded:
Press enter or click to view image in full size
Day 2 staged content:
Press enter or click to view image in full size
Day 2 satellite after staged content has been loaded: for Account ID 1, the change is loaded.
{ account_id: 1, attribute: ‘Change’, loaddate: 2-Jan } differs from
