0

From an on-premise PostgreSQL DB I am trying to take it as source in the mapping data flow of Azure data factory. In postgreSQL DB table their is a column with values '$22.44', their(PostgreSQL DB) one can use MONEY datatype. Is their any alternative to MONEY in the Azure data factory. I can use string, But that is an incorrect way to import the data. So please recommend any other alternative if available.

Thank you!

Pushkar Wani
  • 11
  • 1
  • Use `decimal` or `numeric`. The use of the money type is [discouraged](https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_money) anyway –  Mar 06 '22 at 11:09
  • you can reverse as [this](https://stackoverflow.com/questions/62921774/how-to-convert-currency-to-decimal-in-azure-data-factorys-copy-data-activity-ma) later – KarthikBhyresh-MT Mar 07 '22 at 12:39

1 Answers1

0

There is no explicit data type for money or currency as we have for date and time. You can use either of int or float or decimals or string to store the same.

I see you have already opened this ask in discussion, you can post to support or as an idea here too to get an official response.

KarthikBhyresh-MT
  • 4,560
  • 2
  • 5
  • 12