DSXchange

Posted: **Tue May 19, 2009 11:29 am**

Hi,

I have situation where i need to split a record into multiple records based on date.

InputData :

ID|BeginDate|EndDate
100|2009-01-01|2009-03-31

OutPut :

100|2009-01-01|2009-01-31
100|2009-02-01|2009-02-28
100|2009-03-01|2009-03-32

Any thoughts how to implement this un datastage

Posted: **Tue May 19, 2009 4:04 pm**

Probably a BuildOp.

Posted: **Wed May 20, 2009 2:48 am**

....... or a lookup into a calendar / date table.

DSXchange

split record

split record