Monday, June 24, 2019

Normalizer Transformation

Normalizer Transformation is Active and Connected transformation. It converts single row data into multiple columns data. It converts de-normalized table into a normalized table. You cannot drag & drop columns to normalizer transformation like the rest of the transformations.

* Normalizer is used to convert rows into columns.
* Normalizer is used in the place of source qualifier while reading mainframe or Cobal Source.

 Steps to create Normalizer transformation :-
-----------------------------------------------------------------
- Go to tranformations tab and select normalizer
- Double click normalizer and select the normalizer tab
- Add the occurs based on the requirement





In Normalizer properties tab 'Reset' and 'Restart' are the two options available.

 Reset is used to reset the Gk value to the value, that is used before the session.
Restart is used to start Gk sequence from 1 and restart for each session

There 2 important ports available and they are GK and GCID

GK generates sequence number starting from the value defined in the sequence field.
GCID hold the value of the occurrence field.


at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Date Functions in SQL

Select Getdate() as CurrentDate; Select Getdate() -1 PreviousDate; Select Getdate() +1 NextDate; Select DATEADD(dd,1,getdate()) as NextDate;...

  • Analytical Functions
    The functions SUM, COUNT, AVG, MIN, MAX are the common aggregate functions the result of which does not depend on the order of the records....
  • Update Strategy Transformation
    Update Strategy Transformation is Connected and Active transformation. It is used to insert, update, delete and reject records from a file ...
  • Session parameters & Session variables
    Session Parameter :- ---------------------- Session parameters, like mapping parameters, represent values you might want to change betwee...