DSXchange

I am having on column named as The GECIKME_TRH field datatype is decimal(08 ) in source and in target it is data type is char(08 ). 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.

Could anyone please help in this regard.

Sounds just like this problem:

viewtopic.php?t=123054

How strange. Exactly the same but for the column name.

I know i just replied to one of them

Hi ,

What you are saying is that source and target column are of Char(08 ).
But in your datastage job it is defeined as datetime datatype.

And are you getting 7 characters for all the records or just for few records ?

20081022