I am trying to create a snapshot wherein one of the columns to be tracked is a dollar amount. It comes into Incorta a a decimal, which Incorta won't let me designate as a key. If/when I switch to a long I get a truncated number ( e.g. 55.55 becomes 55 ).
The history is *not* stored in the source so I can't get the changes via SQL against the source.
How can I track changes to that decimal?
Solved! Go to Solution.
Randy, see the Docs page on Decimals and reference the Known Issues section. Unfortunately, Decimals at this time cannot be used as a Key. To avoid the truncation issue, and if the "value" is more important than the data type, you could create another column that is a twin of the Decimal as type = String that should preserve the ####.## format as a string.