Page 1 of 1
help me how to implement this function in datastage
Posted: Tue Feb 16, 2010 5:25 pm
by vikramkola
TO_DATE( '01-07-' || TO_CHAR(PS_D_DAY.YEAR_NUM - 1), 'DD-MM-YYYY' )
help me ,what code should write in transformer stage.
Posted: Tue Feb 16, 2010 5:48 pm
by ray.wurlod
What are you trying to achieve?
July 1st of prior year?
Without a clear specification we would have to guess, which wastes both our times.
Posted: Tue Feb 16, 2010 6:08 pm
by Kryt0n
You would have hoped colleagues can provide sufficient guidance on such a request rather than the need to use dsxchange
Posted: Tue Feb 16, 2010 10:27 pm
by chulett
Looks to be a snippet from
this post.