Submitted Questions

  • Datastage Performance Tuning

    How to improve the Performance Tuning any 5 points


    • Oct 6th, 2017

    1)Set Proper configuration file
    2)Handle null and duplicate values properly
    3)Reduce number of transformers as much as possible
    4)Do not take more than 20 stages in a perticuler job
    5)Use Dataset stage instead of sequential file stage
    6)Use join merge and lookup stages properly

  • Count in Dataset

    How to get the dataset record count? with out using orchadmin command

    Priyanka Sinha

    • Mar 17th, 2016

    1) The Datastage Designer GUI (also available Manager and Director) provides a mechanism to view and manage data sets. It can be invoked in Tools -> Data set management. 2) orchadmin command-line uti...