How is the best way to generate a calendar table in PowerCenter? -
I must generate the table of calendar dates from the days of the date will expire in Powercenter designer.
The Tithiini For example, '2013-01-01' date is fixed sysdate + 'n' months
I'm trying to generate a Java Tranornemeshn, Which can generate many dynamic rows, but there is no input row and I have no input ... there is no other better way to use seq generator in the ???
The example table should be in the form of content results
date ==== === '2013-01-01' '2013-01-02' '2013 -01-03 '... ...' 2016-03-10 '
You can pass an input row from any source to a Java conversion and then you can generate rows with a continuous date in a loop.
You can create a simple table with two columns - Tithiini and Dinankandhi There will be a line which will Kikst both Java code and configuration for mapping.
Comments
Post a Comment