| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: How do you rename all of the jobs to support your new File-naming conventions?
Answer: Create a Excel spreadsheet with new and old names. Export the whole project as a dsx. Write a Perl program, which can do a simple rename of the strings looking up the Excel file. Then import the new dsx file probably into a new project for testing. Recompile all jobs. Be cautious that the name of the jobs has also been changed in your job control jobs or Sequencer jobs. So you have to make the necessary changes to these Sequencers. |
| June 06, 2009 09:35:11 |
#1 |
| DatastageDev |
Member Since: June 2009 Total Comments: 1 |
RE: How do you rename all of the jobs to support your new File-naming conventions?
|
| If you export the jobs in an XML file you can easily do a find and replace for anything using notepad. So if the standard for master is changed from mst to mstr you simply for a find and replace. Or if the jobs are jobnam_dev you and you need to replace the _dev with _test or whatever. |
| |
Back To Question | |
