DSXchange

Hi All,

I need to take a backup of records of 1 year at the end of every seventh year.
How could we implement this scenario .


Thanks
Sunitha

Are you sure that this is a DataStage question or a systems question? You will need to supply a bit more information so that you can get meaningful responses.

Are you looking for logic to implement in DataStage in order to select the correct records and to write a generic job to process the table(s)?

I'm looking for the logic to implement in datastage.

Thanks
Sunitha

DataStage is not really a backup management utility. Prefer the correct tool for the job, and for the job of managing your backup archives (for example IBM InfoSphere Optim Data Growth Solution).

If you really must use DataStage it's just another ETL task - you need to identify a mechanism for determining which records to extract from source, and a mechanism that can trigger once every seven years (this will really need to be a third party scheduler).

sunitha_cts wrote:I'm looking for the logic to implement in datastage.

Then as noted you'll need to detail your requirement, right now it's a little too vague. "Backup" means what in this context? Do you actually mean purge? And "one year at the end of every seventh year" needs to be clarified as well.

Yes it is purge

So... one thing clarified, you want to delete records in spite of putting 'data loading' in the subject. Everything else is still vague though, as noted.