Answered Questions

  • How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm? 

    We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - External Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]") 

    vipul choudhary

    • Aug 22nd, 2013

    There are two types of hash file

    1. modulus hash file- file size increases randomly
    2. splitting hash file-file size decreases randomly

    Muralidhar

    • Jul 29th, 2013

    By default datastage date format is :yyyy-mm-dd.The input is mm/dd/yyyy. String_to_date(inputdate,"%mm%dd%yyyy")