Problem: I have a column in SQL with Real Data type and I want to transfer it to Oracle in a NUMBER data type. In SSIS if I cast the Real data type to Float it generates unwanted float digits
Problem Image:
SOLUTION
This is actually not an issue. You can copy the float at it is. However, due to certain applications that do computation with the values in the column you might want to cast the REAL data type column to DECIMAL (38,10)
Subscribe to:
Post Comments (Atom)
BECOME A BIG DATA ENGINEER IN 3 MONTHS with less than $100 investment
INTRO: Below is my guide to becoming a data engineer based on the current job market (08/08/2020) demands. I have outlined the TOP 5 foun...
-
1. Good Foundational Knowledge of SQL Programming (SQL Query writing) Paid Course The best SQL course that I know. (I have not affili...
-
Hi I was recently working on extracting a table that has 400 columns from a SQL Server DB to load into an Oracle Target Database. I design...
-
In this blog post I will show you how to implement your own custom logging in Azure Data Factory Before you do this please note that Azur...
No comments:
Post a Comment