If I want to create a snapshot of something like: ORDER_NO, AMT with no source DB history I can do that by creating a dense snapshot - but that gives me 1) a lot of rows ( one per snap cadence ) and 2) a lot of duplicate rows for every snap where the AMT *didn't* change.
So I want to create a sparse snapshot which requires both ORDER_NO and AMT to be key values, but ... no go 😞
I know a workaround is to bring in AMT twice, once as a long for the key and once as a decimal for the measure, but long seems to be truncating the AMT so I'd capture 1.50 -> 2.10 but not 1.50 -> 1.99
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.