|
| |
|
DWHlabs provides Data Warehouse education services.This web portal is very useful to the Database professionals,
Data Warehouse professionals, UNIX professionals etc., |
|
|
|
|
|
| |
Please help us continue development of this website and it's services! |
|
|
|
|
| |
|
|
|
| |
|
|
| MAPPINGS PAGE - TRANSFORMATION MAPPINGS - MAPPLET MAPPINGS |
| |
| |
| Mapplet Two |
: |
The object of this mapping is used to obtain the employee info who is getting maximum salary. |
| Explanation |
: |
A mapplet is a reusable object that you create in the Mapplet Designer. It contains a set of transformations and allows you to reuse that transformation logic in multiple mappings.
Mapplet Input :: You can pass data into a mapplet using source definitions and/or Input transformations. When you use an Input transformation, you connect it to the source pipeline in the mapping
Mapplet Output :: Each mapplet must contain one or more Output transformations to pass data from the mapplet into the mapping.
Mapplet Mapping flow
Input mapplet > sorter > filter > expression > output mapplet
Warehouse Mapping flow
source definition > source wualifier > mapplet > target definition
Advantage
Mapplet is used to reuse it in differnt mappings / repositorys |
Certification Point :: |
You cannot include the following objects in a mapplet:
- Normalizer transformations
- Cobol sources
- XML Source Qualifier transformations
- XML sources
- Target definitions
- Pre- and post- session stored procedures
- Other mapplets
|
| |
| |
| |
|
| Download |
: |
|
|
|
|
|
|
|
|
|
|
|
|
Data Warehouse Lab
- ETL TOOL
- REPORTING TOOL
Database Lab
- ORACLE
- DB2
Unix Lab
Project Lab
DWH Schools
Books Store
|
|
| |
|
|
