We will be using DS 7.5 on unix for a conversion project. The total number of jobs developed could run into 800-1000.
The entire conversion process is categorized into subject areas, and each subject area contains a number of tables which are to be populated based on a loading sequence.
we are still in the initial phase of the project(Still to receive the DS 7.5 license , that is how much the initial stage means), but the requirement is that the dependencies for table loading might change. These changes need to be incorporated without changing much of the design.
the design that we thought of was : create jobs in PX to perform the ETL on tables, then write code in BASIC for sequencers to handle the sequencers.
would it be possible to go according to the approach mentioned above?, or is there a better way of doing?
Thanks.
Flexible Sequencing of Sequencers
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can indeed do what you desire.
But it may be more fruitful, if you're not a confident DataStage BASIC programmer, to realise that a Job Activity can start a Job Sequence as easily as it can start a parallel or server job. That is, you can build a hierarchy of Job Sequences, with condition testing at any level to determine what to do next.
But it may be more fruitful, if you're not a confident DataStage BASIC programmer, to realise that a Job Activity can start a Job Sequence as easily as it can start a parallel or server job. That is, you can build a hierarchy of Job Sequences, with condition testing at any level to determine what to do next.
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.
-
- Participant
- Posts: 75
- Joined: Tue May 13, 2003 4:14 am
- Location: California
- Contact: