hello everyone in this video I will explain how to use normalized transformation in Informatica Cloud you can see normalizer transformation is active and connected transformation it transforms one incoming row with multiple occurrence into multiple RADS and it generates GK GCI ID and GK FS as you can see if I have the source like this like B name match one match two match three match four the names are like r s those inside match one 30 runs 15 runs 0o 51 like that and you can see in the Target it will be for each Batman and the runs will be there in multiple roads so column into Rose conversion will happen let's go to ISS let me create the mapping to show how it works go to new click on mapping create aore marer now we want select the source select the con select the source let's go to the field s the fields matchman name match one match two match three match four let's add the normalizer maximize you can see the incoming Fields normalized field we need those fields so select this mats man name it's currence will be one then create a new field it as occurrence will be four as it's occurring four times as you can see in the source it is there four time that's why I have mentioned occurrence as four we can see GCI ID and GK run these two Fields have been autocreated let's go to the field mapping I'll map the back span name here match one to run one match two to run two match three to run three as go to run so as you can see in occurrence I have created one field but occurrence four that's why four Fields have been created here in the field mapping now let's go to the Target you can see incoming Fields if you don't want to populate the GCI and GK you can um uh exclude those here in this example let it be there I want to show you what all values are getting populated now select the flat pile Target connection select I want to create the target during WR time so I make it CSV mapping has been created let's save this mapping let's create the uh mapping task click on new mapping task provide a name mtor mapping name and select the WR time click on next now click on finish so our mapping and mapping task both have been created now let's run the mapping task it's running go to my jobs you can see here the the job is running now task is running it has completed click on this and you can see from Source three records are coming but in Target 14 records have been loaded let's go to the Target paths yeah this is the target file which have been generated now yes as you can see here 14 records have been loaded let's take it to the F and so there yeah you can see here for this record r four records are there you can see four entries four records have four fields are there you can see four records have been generated 051 305 051 similarly for the next set of Records which I loaded and uh you can see jkon jkon it will generate the sequence or the number of Records it will the it will create the sequence like 1 2 3 4 as 12 records are there does generate the sequence as 1 to 12 and you can see here for this combination for this ran record it has generated 1 2 3 4 for this Santos generated 1 2 3 4 it means for that occurrence it will show it will create the number of Records number of sequence so you can see here in this way the column to row conversion happens using the normalizer transform thank you