cancel
Showing results for 
Search instead for 
Did you mean: 

How do I use a native decimal ( dollars and cents ) as a key?

RADSr
Partner
Partner

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?

1 REPLY 1

JeffW
Employee
Employee

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.

https://docs.incorta.com/cloud/references-decimal-data-support