Showing results for 
Search instead for 
Did you mean: 
Status: New

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