|
| |
|
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 - NORMALIZER TRANSFORMATION |
| |
| |
| Transformation |
: |
Normalizer (nrm_) |
| Explanation |
: |
Normalizer transformation is a active and connected transformation.
| |
| |
| DESIGNER :: |
| |
Use the Normalizer transformation with COBOL sources, which are often stored in a denormalized format |
| You can also use the Normalizer transformation with relational sources to create multiple rows from a single row of data. |
| |
| MAPPING :: |
| |
Objective : To create a mapping which converts a single row into multiple rows.
Mapping Flow : Source Definition (Flat File) > Source Qualifier > Expression (column names) > Normalizer transformation (converts single row into multiple rows)> Target Definition (flat file)
Designing : We designed this mapping using INFORMATICA tool version 7.1.1 .
Description :
Source Definition
ENO |
ENAME |
ESAL |
EAGE |
100 |
JOHN |
2000 |
23 |
101 |
SMITH |
5000 |
41 |
102 |
LUCKY |
6000 |
32 |
Target Definition
ENO |
COL_NAM |
COL_VAL |
100 |
ENAME |
JOHN |
100 |
ESAL |
2000 |
100 |
EAGE |
23 |
101 |
ENAME |
SMITH |
101 |
ESAL |
5000 |
101 |
EAGE |
41 |
102 |
ENAME |
LUCKY |
102 |
ESAL |
6000 |
102 |
EAGE |
32 |
Download : source file click here (flat file)
|
|
| Download |
: |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
Data Warehouse Lab
- ETL TOOL
- REPORTING TOOL
Database Lab
- ORACLE
- DB2
Unix Lab
Project Lab
DWH Schools
Books Store
|
|
| |
|
|
