data trunction when i am load into target as sql server
Moderators: chulett, rschirm, roy
data trunction when i am load into target as sql server
My Source have sql server datatype has number,target have sql server datatype has sql server.When i am loading soure to tartget,data will be truncated.
Ex:Source has 16.8 target loaded to 16.799992372605.
i am not use any convertion function.Please let me know have idea in this.
Ex:Source has 16.8 target loaded to 16.799992372605.
i am not use any convertion function.Please let me know have idea in this.
Re: data trunction when i am load into target as sql server
kethya11 wrote:target have sql server datatype has sql server.
Anyway, perhaps the replies here can help, even if they are about Oracle.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: data trunction when i am load into target as sql server
Use the Sever job to load and compare the value.
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: data trunction when i am load into target as sql server
Can you please report the SQL data type, the precision and the scale for this column on both source and target?kethya11 wrote:My Source have sql server datatype has number,target have sql server datatype has sql server.When i am loading soure to tartget,data will be truncated.
Ex:Source has 16.8 target loaded to 16.799992372605.
i am not use any convertion function.Please let me know have idea in this.
"sql server" is not a data type.
Please advise also whether you imported the table definitions from source and from target before constructing this job?
Finally, please advice with which stage types you are connecting to the SQL Server database(s).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: data trunction when i am load into target as sql server
Hi Ray,
Thank for your reply
i am wrongly posted datatype ,datatype has float .Its no precision and scale values.
After construct the job am imported the meta data.I a, I am using the odbc connecter stage.
Please help me.
Thank for your reply
i am wrongly posted datatype ,datatype has float .Its no precision and scale values.
After construct the job am imported the meta data.I a, I am using the odbc connecter stage.
Please help me.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The float and dfloat data types are not guaranteed to store data to the final significant digits accurately. Research the IEEE specifications for storing these data types for the reasons why. I'd suggest you specify at least a scale value (ideally a precision value also), and perhaps treat the data type as decimal (though you may have to ignore/demote metadata mismatch warnings).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: