Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - What main advantage of Stage variables?

asked mar September 20, 2014 06:32 AM  

What main advantage of Stage variables?


1 Answers

answered By vishnoiprem   0  
  • The main advantage of Stage Variables is to reduce the repetition of the code for all the required columns in the Transformer.
  • Say for e.g., If you are having 10 lines of code to be used for all the derivations of columns in the transformer, We declare a Stage variable once and we assign these 10 lines of code to that variable and can place this Stage variable where ever needed in the derivation of the columns in the Transformer Stage. Th scope of these variables is limited with in the stage it is created.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!