We are documenting details regarding our datastage jobs.Sometimes we need to copy columns and their derivatons in the transformer stage to a word document or excel sheet.
If a table has 50-100 columns,it is difficult to copy these columns and their derivations one by one.Is there a way that we can copy all the columns and their derivations of a table in the transformer stage to a word document or excel sheet at once.
In DS Designer under the "File", there is an option called "Generate Reports", Using this you can get in HTML page. Inthat if any derivation is used in the transformer it will show as it is in the job. Simply passed column will go as such. Copy those derivations and paste in word or excel
In DS Designer under the "File", there is an option called "Generate Reports", Using this you can get in HTML page. Inthat if any derivation is used in the transformer it will show as it is in the job. Simply passed column will go as such. Copy those derivations and paste in word or excel
Thanks for your quick reply.When I checked in DS designer there was no Generate reports option under Files.Could it have something to do with the DS version we are using.We are currently working on version 7.1.
Is there any such option present in DS manager or DS director?