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
Can I use DataStage to backup records?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
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)?
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)?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.sunitha_cts wrote:I'm looking for the logic to implement in datastage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact: