I have a scenario wherein I have to generate date values within some limit. I have to fetch min(cal_date) and max(cal_date) from my source table and generate date values within these values in my target table.
How can I pick these dates and generate the date values from min(cal_date) and max(cal_date) dynamically in my job?
Have max(date) and Min(date) from the source, use transformer and stage variable to check till the limit of Max(date) and increment the current date by 1 for each record.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Do you only ever get 1 minimum value and 1 maximum value from the database, or do you get 1 min and 1 max for each set of key values in the source table i.e. are you grouping by some key values?