XTS sample code

Data Vault 2.0
1

Hi everyone,
I’ve read through articles relating to handling late arriving / out of sequence data and have read chapter 8 in Patrick’s book - all that cover off the Extended Tracking Satellite (XTS)

Lots of sample pseudo code in there which is great - is there a location where this code is available to download, to save me lots of time writing SQL, especially the satellite load pseudo code?

cheers,
John

2

Hi John,

I made a macro for the AutomateDV package that includes XTS implementation, not sure if you’re using this or not but you can still have a look at what that generates to get an idea for your own implementation.

ADV-XTS code

All the best,
Frankie

3

Thanks @Frankie. In this instance, dbt isn’t part of the landscape. In the end, I have managed to get a working version in standard SQL using a variation of the code presented in Patrick Cuba’s book.