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.
DataType
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 78
- Joined: Wed Jun 04, 2008 2:59 am
DataType
Warm Regards,
Vijay
Vijay
Sounds just like this problem:
viewtopic.php?t=123054
How strange. Exactly the same but for the column name.
viewtopic.php?t=123054
How strange. Exactly the same but for the column name.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 51
- Joined: Sat Dec 09, 2006 3:32 am
Re: DataType
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
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
------------
Elias
Elias