I am stuck on a problem here.. I have a source table with year-month column along with other fields. I have to generate date data for given month of source table. Ex: 2004-03 in source table, i have to populate 2004-03-01,2004-03-02,....2004-03-30 etc. along with other columns. Can we implement this in datastage?
Source
1 paul 2008-03
Target
1 paul 2008-03-01
1 paul 2008-03-02
1 paul 2008-03-03
........
1 paul 2008-03-31
generate multiple rows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Time dimension table with multiple-row return enabled from the lookup, or via an inner join on the year-and-month.
Tip: "Numeric date" fields yyyymmdd and yyyymm are very useful in time dimensions.
Tip: "Numeric date" fields yyyymmdd and yyyymm are very useful in time dimensions.
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.