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.
Tags:Interview Questions, Data Warehouse, DataStage,
Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.
Sponsor Advertisement
Customer Resource Management Software
CRM software is designed to help businesses in manageing their customer data and customer interaction, access business information, automate sales, marketing and customer support and also manage employee, vendor and partner relationships. ...
No comments:
Post a Comment