How is the best way to generate a calendar table in PowerCenter? -

How is the best way to generate a calendar table in PowerCenter? -

i must generate table of calendar dates dateini dateend in powercenter designer.

dateini is fixed, illustration '2013-01-01' dateend sysdate + 'n' months

i'm trying generate java tranformation, can generate several dynamic rows needs input row , not have input... there other improve approach using seq generator???

as illustration table content result must be

date ======= '2013-01-01' '2013-01-02' '2013-01-03' ... ... '2016-03-10'

you can pass single input row source java transformation , generate rows consecutive dates in loop.

you can create simple table 2 columns - dateini , dateend. contain single row both kickstart java code , provide configuration mapping.

informatica-powercenter