topic Re: How do I use a native decimal ( dollars and cents ) as a key? in Administrative Discussions

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

RADSr — Tue, 19 Dec 2023 21:02:08 GMT

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?

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

JeffW — Tue, 02 Jan 2024 16:37:44 GMT

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