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.
How to loop through sql and print output time
how to create a table with result set in sql server
Why Merging Empty Partition Boundaries of a Partition Functions is generating a lot of Data in the Transaction Log
I am getting Status as “Not Started” in installing setup files step while installing SQL Server 2012 Advanced edition
How to Keep Modifier ID in System Versioned Temporal Tables?
Divide by zero with power function
Using XML as a method parameter in Codefluent
SQL Server 2014 job error
SQL SERVER 2008 Select statement
How do I investigate created a table syntax in SQL?
Group BY inside a subquery
How to STOP SQL Services on multiple servers using powershell
Export database schema into XML file
Is it possible to ignore SQL table alias?
Failure to Install SQL Server Evaluation
SQL Server filtering out string but leave empty strings