DSXchange

Hi All

I have to create/replicate some tables from one schema to another.
There are no stages between the Source Oracle stage and the Target Oracle stage

If there are 10 tables I am creating 10 different jobs for the same.
Please let me know if there is a work around for the same like parameter substitution or anything of that sort...
Also the structure varies from table to table.

Thanks in advance

Anand K

You can't change the metadata dynamically and execute multiple times with different parameter. The best thing is to create sql files and call from datastage by passing parameters

Siva

This is an example where DataStage is probably unnecessary. Use Oracle bulk unloader to unload to stdout, and pipe that result to Oracle bulk loader to load from stdin.