All,
I need to build a calendar with in datastage to generate surrogate keys for time dimension. I know datastage has in-built calendar but need to build a calendar from Given start date to end date using datastage functions.
Is anyone accomplished this before? If so, Could you let me know the options and best way to do it?
Calendar Build
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What you "know" isn't true. DataStage does not have a built-in calendar.
This is a singularly easy task to accomplish. You need parameters of start date and end date. Use a before-job subroutine to write all of those dates into a file, and the job itself processes the dates. (An after-job subroutine might even delete the file.)
This is a singularly easy task to accomplish. You need parameters of start date and end date. Use a before-job subroutine to write all of those dates into a file, and the job itself processes the dates. (An after-job subroutine might even delete the file.)
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.