Database Reference
In-Depth Information
Reuse me please - reusable transformation
As you are aware, source and targets are reusable components, that is, you work on sources
in the Source Analyzer and targets in the Target Designer, respectively. Also, you must be
aware that you cannot edit sources and targets in the Mapping Designer, and they can be
edited in Source Analyzer and Target Designer, respectively.
Sources and targets are called reusable components because you can use the same source
and target in multiple mappings. We can reuse the source or target across multiple map-
pings only if the metadata requirement of both the mappings is exactly the same. In this
case, metadata means the number of columns, their data type, their data size, indexes, con-
straints, and so on. Even if there are small changes, you cannot reuse the components.
On the same lines, if we have the same logic to implement across multiple mappings, we
can use the reusable transformations, which allow us to reuse the same transformation
across mappings. You can only reuse the transformation if the metadata requirements in the
mappings are exactly the same. Even if there is a small difference, the reusable transforma-
tions will not work as there can be mismatch in the processing.
There are two ways in which you can create reusable transformations:
• Using the Transformation Developer
• Making existing transformations reusable
