date transformation

datastage1 · Post by **datastage1** » Fri Aug 25, 2006 7:55 am

How to do date transformation if we have two different databases at the source and target?
Thanks and appreciate the helpful answers

DSguru2B · Post by **DSguru2B** » Fri Aug 25, 2006 8:00 am

What kind of date transform do you need ?
There are many ways. You have routines in the SDK, you can write your won server routines, have a shell manipulate the date as a before job routine.

Advice: Research the manual, you will find alot ways to do that. Moreover the forum is rich with such questions. Its worth spending the time to search.

DeepakCorning · Post by **DeepakCorning** » Fri Aug 25, 2006 11:20 am

Well, if I define the field to be date time stamp in the source and target stage , DS will not take care of the conversion?? In the source it will convert it to string format...process it and then while inserting convert it back to date format of the specific DB...

NBALA · Post by **NBALA** » Fri Aug 25, 2006 12:50 pm

Hi,

Please be specific..

Its all depends on which source and target you are using (Oracle, SQLServer, Flat file.....) and what format you required as output and what is input format. Search in this forum you will get lot Date related post that will calrify your doubts.

-NB

I have never in my life learned anything from any man who agreed with me. - Dudley Field Malone