A developer needs to import a file into a data extension which contains transactional data. The file includes a column labeled Purchase_Price with values varying from '$.05' to '$100'.
What Data Type should be used to prevent loss of data'
The best Data Type to use for the Purchase_Price column, which includes values ranging from '$.05' to '$100', is Decimal(9,2) (C). This data type ensures that values are stored accurately without data loss, allowing for precision up to two decimal places.
[References:, Salesforce Marketing Cloud Data Extensions, Decimal Data Type, ======================, ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit