microseconds getting trucated while loading intoOracle 11g
Posted: Thu May 26, 2011 8:51 am
Hi All,
I am on Datastge 7.5 and I have file from which I load process_date time coumn
In Input file I have value as 23-MAY-11 02.50.21.689000
In datastge job at target stage the column is defined as timestamp 26 with extended propert set to Microseconds
when my job run and loads data into oracle 11g table value of process date time is becoming 23-MAY-11 02.50.21.000000 i.e microseconds are not showing.
in oracle table column is defined as timestamp(6)
if I use the same value and same datastage job and loads data into same table on 10i then data is getting inserted correctly that with microseconds
there also column is defined as timestamp(6)
on datastge job I use simple insert query to load the table ( target stage)
Is this compatibilty issue on Datasteg 7.5 and oracle 11g
I am on Datastge 7.5 and I have file from which I load process_date time coumn
In Input file I have value as 23-MAY-11 02.50.21.689000
In datastge job at target stage the column is defined as timestamp 26 with extended propert set to Microseconds
when my job run and loads data into oracle 11g table value of process date time is becoming 23-MAY-11 02.50.21.000000 i.e microseconds are not showing.
in oracle table column is defined as timestamp(6)
if I use the same value and same datastage job and loads data into same table on 10i then data is getting inserted correctly that with microseconds
there also column is defined as timestamp(6)
on datastge job I use simple insert query to load the table ( target stage)
Is this compatibilty issue on Datasteg 7.5 and oracle 11g