DSXchange

Hi

I am trying to load date(along with time)from seqfile to Oracle table.

Source(Seq file) -Timestamp

Target (Oracle table) - Timestamp

I also want the time to be populated in target.

Source

2008-10-14 19:39:09.000

Expected Target

2008-10-14 19:39:09.000


Note :

Oconv(Iconv(Substrings(Extraction_Data.MODIFYDATE,1,10),'D-YMD'),'D-YMD') : Oconv(Iconv(Substrings(Extraction_Data.MODIFYDATE,11,19),'MTS'),'MTS')
works perfectly and I am able to load 2008-10-14 19:39:09 in target


Can anyone let me know how would we populate tthe expected date(along with timestamp) in target.


Thanks
Kiran

I don't know what you're asking here - you've asked how to do something then described a solution that works. You've also marked the question as relating to a server job yet posted it in the Enterprise Edition forum. This is like asking your greengrocer why your blood pressure is elevated.

Hi Ray

I will be more specific.

Source

2008-10-14 19:39:09.679

Expected Target

2008-10-14 19:39:09.679


I am able to load data into target which is 2008-10-14 19:39:09
but not "2008-10-14 19:39:09.679"

The millisecond sholud be captured(.679)


Thanks
Kiran

Is your job server or parallel?
If it is parallel then enable the microseconds checkbox in the extended properties and propogate till your target.

FYI.We are using Datastage 7.5 server edition

And here we are.

The stage (or you) are using TO_DATE() to populate the target, I assume. Use TO_TIMESTAMP() instead.