Replicate Datasets into another environment
Posted: Thu Nov 15, 2012 8:27 pm
Hi. I'm trying to replicate the various datasets that exist for my datastage solution to help with testing.
My approach is to create a sequence, which loops through either a table of dataset filenames, or perhaps just reads through the entire directory of dataset header files, and populates a parameter which is then passed to a job which copies the data from the applicable dataset in one environment to an equivalent one in the other environment. This job would use runtime column propogation so I don't have to define the column set for each. Should be generic enough.
I don't think the jobs themselves should be too complex, but I'm struggling to know where to start with setting up the parameter(s) to populate, what are the loop conditions etc
Could someone clever please give me some pointers please ?
Thank you,
Nick.
My approach is to create a sequence, which loops through either a table of dataset filenames, or perhaps just reads through the entire directory of dataset header files, and populates a parameter which is then passed to a job which copies the data from the applicable dataset in one environment to an equivalent one in the other environment. This job would use runtime column propogation so I don't have to define the column set for each. Should be generic enough.
I don't think the jobs themselves should be too complex, but I'm struggling to know where to start with setting up the parameter(s) to populate, what are the loop conditions etc
Could someone clever please give me some pointers please ?
Thank you,
Nick.