Saturday, September 30, 2006

How to--Informatica7.1:How to create a simple normalizer

How to create a simple normalizer....?

We need a normalizer to normalize the denormalized data.Means if data is coming in denormalized format from source we simply want to to store in normalize format in target.

Say..if the data in the source table is like

ENAME SAL1 SAL2 SAL3
ram 100 200 300
sha 1100 2200 3300

And its might possible if in the source table some hitorical data maintaining is going on.
But while migrating say you want data like this...

NAME ALLJOB
ram 100
ram 200
ram 300
sha 1100
sha 2200
sha 3300

Then we can do it by normalizer transformation.Normalizer creates multiple rows from a single row.Most of the times normalizer is used for cobol data source.
In edit normalizer transformation-->normalizer tab-->create two fields as we have two incoming ports from the source transformation,here you need to know which one is master and which one is detail fields among the two.In our case ENAME is the master and SAL is the detail field.And for each MASTER,detail is to be repeated thrice in the target.So make the occurence of the detail field in normalizer tab as three.-->connecty the input port appropriately with the incoming transformation and output port with the target table.

GK and GCID
==============
GK and GCID is informatica generated keys and can be used as unique identifier of the new normalized data.GK will be increased one by one for each insertion of rows into the target table and GCID will have rotating values as per the number of occurance of detail field in the source.A sample run and the result from target is:

NAME ALLJOB GK_ALLSAL GCID_ALLSAL
ram 100 1 1
ram 200 2 2
ram 300 3 3
sha 1100 4 1
sha 2200 5 2
sha 3300 6 3

Still I dont know much about the level in normalizer tab..:(
---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Labels:

0 Comments:

Post a Comment

<< Home