Page 1 of 1

datastage requirement?

Posted: Sun May 24, 2015 8:08 am
by pkll
Hi all,

in data stage i have one requirement.
In data stage i have to assin if

Monday = A or
Tuesday = B or
Wednesday = C or
Thursday =D or
Friday = E or
Saturday = F or
Sunday = G.

Let me know how to find today is monday or tuesday or ........Sunday.

Thanks for your advanced help....

Posted: Sun May 24, 2015 8:23 am
by chulett
:idea: The Parallel Job Developer's Guide has an excellent appendix listing the functions available, including one for returning the "day of week" from any date. Give it a look when you have questions like this.

Posted: Mon May 25, 2015 7:54 am
by pkll
Thanks for your reply....working fine.