Class14 - Informatica Powercenter ETL

TOPIC DISCUSSED

NORMALIZER TRANSFORMATION

1. ACTIVE TRANSFORMATION AND CONNECTED
2. USED TO TRANSFORM SINGLE INCOMING ROW INTO
MULTIPLE OUTPUT ROWS OR
USED TO CONVERT COLUMN INTO ROWS

3. INFORMATICA WILL GENERATE TWO COLUMNS IN MRN TRANS
1. GKID - GENERATED KEY IDENTIFICATION
--USED TO GENERATE SEQUENCE OF ID'S
2. GCID - GENERATED COLUMN IDENTIFICATION
--USED TO GENERATE COLUMN ID
(REPEATS THE SEQUENCE BASED ON OCCURS CLAUSE)

4. PROPERTIES TAB OPTIONS
RESTART - WILL ALWAYS START THE ID'S FROM 1
RESET - IT WILL ALWAYS START FROM THE LAST
EXECUTION ID VALUE

NOTE: BY DEFAULT WHEN WE CREATE A NRM TRANSFOMRATION
WE CANT DRAG THE PORTS FROM UPSTREAM INTO NRM TRANS