In a data integration project there are many processes which may share common data transformation requirements. Deployment of reusable transformation objects in these cases avoids duplication of metadata, reduces the development time and provides centralized change control.Once an object is defined as reusable, it can be called in any mapping or mapplet. Several types of transformations such as lookups, aggregators, expressions, routers, and sequences can be defined as reusable objects. This mapping template illustrates the use of an Expression transformation as a reusable object. Implementation Guidelines:

• In this example a common standard is adopted for processing addresses. Logic for every element of the address is coded in the expression EXP_ADDRESS. The expression is generic enough to accommodate up to four address lines, city, state, country, county, postal code and email. This expression is shared as a reusable object and can be used across multiple mappings that would process address information e.g. Mappings that load the customer dimension and the employee dimension respectively.

You can download this listing as part of the Bundle : Various Transformations - 1.