sql-server
Currency datatypes in Pentaho Kettle to load to MS SQL Server
What is the best way to handle currency fields using Pentaho Kettle when the end-goal is to load the data into MS SQL Server? MS SQL Server has a "money" data type, but this isn't available in Pentaho. I could convert the column to a string, and then strip out the currency symbol before loading as some sort of floating decimal numeric data type, but that seems manual and I would guess that Pentaho has more sophisticated built in capabilities. Thanks.
Related Links
Matrix-like comparison of two query results
MICROSOFT SQL Server Enterprise Core Edition - How many licenses do I need for a 96 core server? [closed]
SQL Server Agent user/password login for network
Is DROP CONSTRAINT of default values a size of data operation
why does getdate returns 1\1\1900
Connected two PC's with ethernet cable but not able to access SQL Server from other machine using Management Studio
How to resolve Azure data Migration blocker User: has an unresolved reference to Login
sql spatial search, find coordinates on a route in certain radius
SSMS: Database could not be detected as it is linked. Make sure that the user has linked a database to source control
Pivot query in SQL Server
Dynamic flat file connection string in SSIS
Singelton cluster in K-means sql server ssas
How to use the hierarchyid type of SQL Server in petapoco?
LIMIT not working in SQL
Remove some characters from string sql [duplicate]
Narrowing down results