title: what is the equivalent function for FormatNbr(DTSSource("Commission_Rate_2"), 8, 4) in informatica
body: <p>In DTS function DTSDestination(&quot;Commission_Rate_2&quot;) = FormatNbr(DTSSource(&quot;Commission_Rate_2&quot;), 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.</p>
  <p>Ex : for input 9.75 need output as 00097500
  and for input 652.5 need output as 06525000</p>