DSXchange

--------------------------------------------------------------------------------





I am having on column named as HIRE_DT The field datatype is decimal( in source and in target it is data type is char(. This field's data type is datetime as 20081022,but for my job's output i am getting this field has 7 characters such as '2008102' , the last character is missing . The design is external source and transformer and target is sql server.

and your issue is ?

It's just possible that 2008102 means the 102nd day of 2008. You need to determine what the rules are, and why you're getting seven digits and whether this is correct. We can't help with that - it's something that you have you resolve with the provider of the data.

i had such issues in DB2 to TD migration. if its ending up in seven characters then Ray is right that the last three are respresting the day number i.e. 102nd day of the year. in TD we have Sys_calender.Calender to check if its mapping to the right date in this case 102nd day = 22nd of december. though does'nt seem right because it should be 11th April