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

DataStage - If we take 2 tables(like emp and dept), we use join stage and how to improve the performance?




586
views
asked mar September 20, 2014 06:32 AM  

If we take 2 tables(like emp and dept), we use join stage and how to improve the performance?


           

1 Answers



 
answered By vishnoiprem   0  
  • We can  improve the performance based on key columns in EMP and DEPT joins by default sort in datastage
  • for better performance if you have already a sorted data just go for environmental variables and do the operation #APT_Not_SORTDATA option then performance increase automatically.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  1 person following this tag

  Question tags

datastage × 4

Asked 2 years and 3 months ago ago
Number of Views -586
Number of Answers -1
Last updated
3 years and 2 months ago ago

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!

Alert