Need help in building the logic

[Sainath.Srinivasan]

Build the dataset inside a sequence or loop using the values as each year will contain 12 months.

So for Apr-2005 to today, it will be 4 full years + 2 partial ones.

Alternatively you can create a server job to prepare the list of values into a seqential file and call that prior to your current job.

[ray.wurlod]

Basically the approach that Sainath suggested, plus you can use the MONTH.LAST transform to generate the date of the last day of a month. You can do that in a User Variables activity or directly in the expression the provides the value to the job parameter.

[pradkumar]

Thanks for your reponses. I will try these options and let you know if i get any issues.