Hi,
Can anyone help to understand if there is any function in datastage to get the working day of last month i.e. say the month end is 31-May-2008, then we need to see if the month end day falls on weekend if so we need to get the friday(30-May-2008) and pass it to the target. In this example 31-May-2008 is saturday, so we need to pass the 30-May-2008 to target as it's a friday.
I know we can implement it by using a time dimesion, i like to know if we can implement the same without using the time dimension.
I appreciate any help on this.
regards,
senthil kumar
Working day of last month
Moderators: chulett, rschirm, roy
The simplest, easiest, most scalable and flexible solution seems to be avoided most of the time.
Why not write a function that has an internal array of all days for the last+next 500 years that lists all of the holidays? Another function that lists all of the work days? Another function that correlates all of the days to their last day of the month? Where does it end?
There is NO magic algorithm that gives all answers to all questions, unless folks want to argue about GUT/TOE.
Why not write a function that has an internal array of all days for the last+next 500 years that lists all of the holidays? Another function that lists all of the work days? Another function that correlates all of the days to their last day of the month? Where does it end?
There is NO magic algorithm that gives all answers to all questions, unless folks want to argue about GUT/TOE.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Have you searched the forum for it? This post for instance?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.