informaticaiics

what is the equivalent function for FormatNbr(DTSSource("Commission_Rate_2"), 8, 4) in informatica

In DTS function DTSDestination("Commission_Rate_2") = FormatNbr(DTSSource("Commission_Rate_2"), 8, 4) converting the input 652.5 as 06525000 and 9.75 as 00097500 what is the equivalent function to convert column value as 652.5 and required output as 06525000 in informatica.

Ex : for input 9.75 need output as 00097500 and for input 652.5 need output as 06525000

Solution

  • You can use lpad and multiply by 10000. Use

    LPAD((col*10000),8,'0')

    col*10000 - will made 9.75 to 97500
    lpad(97500 ,'0',8) - will output 00097500

    Pls note this will be a string data type.