|
|
|
DESIGNER MENU |
| |
MAPPLETS
When you have to create a Mapplet ?
If in a need of particular set of transformations which uses same logic in multiple mappings.So that you can reuse the group of transformation in multiple mappings.
Create Mapplet
- You can create Mapplets in Mapplet Designer Tool.
- Mapplet Input Transformation is used only when you dont want to use the Source Definition in Mapplet Designer.
- Mapplet Output Transformation is always used when ever you create Mapplet.
- Example Mapplet Flows
Source > Sorter > Expression > Mapplet Output
Mapplet Input > Sorter > Expression > Mapplet Output
|
Advantages
- Include source definitions. You can use multiple source definitions and source qualifiers to provide source data for a mapping.
- Accept data from sources in a mapping. If you want the mapplet to receive data from the mapping, you can use an Input transformation to receive source data.
- Include multiple transformations. A mapplet can contain as many transformations as you need.
- Pass data to multiple transformations. You can create a mapplet to feed data to multiple transformations. Each Output transformation in a mapplet represents one output group in a mapplet.
- Contain unused ports. You do not have to connect all mapplet input and output ports in a mapping.
|
Limitations
- Must use a reusable Sequence Generator transformation.
- Normal Stored Procedure transformation alone can be used.
- Cannot use
- Normalizer transformations
- COBOL sources
- XML Source Qualifier transformations
- XML sources
- Target definitions
- Other mapplets
|
|
