I would like to create a common module that would be used multiple times to populate our Operation Data Mart. The Operational Data Mart contains start and end times, failure or successes, counts etc. This common module would be a unique DS program that would accept parameters and write records to the data mart. The problem we face is that multiple sequences may call the same program simultaneously and DS doesn't like this.
Does anyone have any suggestions on how we may accomplish this without creating multiple duplicate programs. It seem odd that DS doesn't handle reuseable modules to well.
Thanks,
Common Module
Moderators: chulett, rschirm, roy
Common Module
Jim Stewart
Re: Common Module
Raftsman wrote: The problem we face is that multiple sequences may call the same program simultaneously and DS doesn't like this.
Does anyone have any suggestions on how we may accomplish this without creating multiple duplicate programs. It seem odd that DS doesn't handle reuseable modules to well.
The special program, is it a DS Job? If it is you can enable multiple instances feature on this Job and use it so that each sequence will call an instance of this special Job.
You can enable this feature for any job in the Job Properties.
Hope that helps.
~Kris
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
When you use multiple instance jobs you can access the macro - I think it's called DSInvocationID - as though it's a job parameter. You can use it in file names and in transformers. It's handy for passing in a code to an instance and embedding it into your file paths and file/dataset names.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn