Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
ksk
Participant
Posts: 21 Joined: Fri Apr 30, 2010 4:55 am
Post
by ksk » Thu Jul 01, 2010 2:32 am
Hi,
I have extracted the data from oracle to datastage(oracle stage) .
but there is a change in the column data type.
when i extract a column of date type in oracle comes as timestamp in datastage why?
Thanks in davance
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Jul 01, 2010 3:13 am
Because Oracle stores all dates with a time component.
Oracle is... different.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Jul 01, 2010 5:40 am
LOL... welcome to Larry's world.
-craig
"You can never have too many knives" -- Logan Nine Fingers
krishnuka123
Participant
Posts: 5 Joined: Sun Jan 15, 2006 11:45 pm
Contact:
Post
by krishnuka123 » Sat Jul 03, 2010 4:02 am
Should use : Given in below
Column SQL Type
Date VarChar
I believe it will work.
M.K.Madhav
priyadarshikunal
Premium Member
Posts: 1735 Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI
Post
by priyadarshikunal » Mon Jul 05, 2010 4:01 am
@krishnuka123
why do you think it needs to be converted to Varchar to read a oracle date field?
In datastage it works perfectly fine using timestamp as datatype.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.