One of the features of Informatica's PowerMart (V5.x), was the rather simple ability to create jobs en masse to quickly be able to just do a raw copy of a database to another. It was extremely limited, but suited our needs fairly well because it didn't have to be real efficient at the time.
I'm looking for any similar utilities that might exist for DataStage. Basically, I want to be able to give it a source and target, point the utility to my metadata and have it build 2 jobs for each table: 1 - extract the data to a sequential file and 2 - load the sequential file to the target. I just want it to build a generic .dsx file to import into my project.
If one doesn't exist, I can't think of a better way to get more into the inner workings of DataStage than to take on a challenge and go play!
![Shocked :shock:](./images/smilies/icon_eek.gif)
If it doesn't exist, I guess I'm going to need to know if there is a command line utility for extracting and/or loading metadata from source databases to DataStage? I'm sure I'll think of other questions as well as I go along. I'll just post them as I run across them.
One of my primary concerns is to write it in a way that makes it useful for both Unix and Windows environments. I know I'm just running on AIX Unix, but I want it to work on Windows as well so that if anyone else can use it, I can make it available. I'll be writing it on my own time, so we'll see how long this takes.
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
As always, any input or existing solutions would be greatly appreciated,
Bestest!