Informartica Re usable expression transformation for implementing operation as of TRIM in Oracle

Save below metadata in a notepad file and rename file extension to xml from txt. Then import xml file through PowerCenter Designer.


<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE POWERMART SYSTEM "powrmart.dtd">
<POWERMART CREATION_DATE="05/14/2012 09:08:53" REPOSITORY_VERSION="181.90">
<REPOSITORY NAME="PowerCenterDev02" VERSION="181" CODEPAGE="Latin1" DATABASETYPE="Oracle">
<FOLDER NAME="DATA_QUALITY" GROUP="" OWNER="nsmith6" SHARED="NOTSHARED" DESCRIPTION="" PERMISSIONS="rwx---r--" UUID="e6cb008b-b2cf-4b8c-bde3-b1f4d118473a">
    <TRANSFORMATION DESCRIPTION ="" NAME ="EXP_TRIM" OBJECTVERSION ="1" REUSABLE ="YES" TYPE ="Expression" VERSIONNUMBER ="1">
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR1" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR1))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out1" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR2" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR2))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out2" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR3" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR3))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out3" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR4" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR4))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out4" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR5" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR5))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out5" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR6" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR6))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out6" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR7" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR7))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out7" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR8" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR8))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out8" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR9" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR9))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out9" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VR10" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1000" SCALE ="0"/>
        <TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR(&apos;transformation error&apos;)" DESCRIPTION ="" EXPRESSION ="LTRIM(RTRIM(VR10))" EXPRESSIONTYPE ="GENERAL" NAME ="VR_out10" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1000" SCALE ="0"/>
        <TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
    </TRANSFORMATION>
</FOLDER>
</REPOSITORY>
</POWERMART>