Scenario:
We are creating hundreds of passthrough mappings that need to store numeric source data columns as varchar2 string columns in the target Oracle staging tables. (This is to bypass a current iDQ bug where large numbers are presented in profiling results in scientific notation - KB 117753).
Unfortunaly Powercentre pads all available significant places with zeros.
E.g. a source column (15,2) passing value 12.3 into a target column of varchar2(20) will populate with "12.3000000000000".
Can
this be avoided without manipulating each mapping with an additional
expression with a string function and new output port for each column?
Solution:
Enabling high pression ensures the source data type (both scale and prescision intact).
So if you want to avoid trailing 0's, u can use TRIM function in the SQ override query.
We are creating hundreds of passthrough mappings that need to store numeric source data columns as varchar2 string columns in the target Oracle staging tables. (This is to bypass a current iDQ bug where large numbers are presented in profiling results in scientific notation - KB 117753).
Solution:
Comments
Post a Comment