DSXchange

Posted: **Thu Apr 17, 2008 6:08 pm**

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

Posted: **Thu Apr 17, 2008 6:34 pm**

(channelling Ken) Time Dimension!

Posted: **Thu Apr 17, 2008 7:25 pm**

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.

DSXchange

generate multiple rows

generate multiple rows