Step 9: Once this is done, you can connect the Normalizer transformation ports to the target ports or target transformations. You can check that the previous transformation is connected to Normalizer transformation with the new ports that are created. When you check the Normalizer transformation now, you will be able to see that all the Result Attributes are present in the transformation. Step 8: Once this is done, if you go back and check the ports, you will observe that the ports have increased automatically for the Result Attribute. This number can be changed as per the requirement. As there are 5 results, the occurrence of this field is changed to 5. Similarly, the other two columns can also have their Level 2 created. This creates a new column and shifts the WEEK_ID column to level 2. Step 7: After this, you can select a particular column to say Week_ID and create the next level by selecting the Level Button’s right shift. The data type and precision should be matching with input and output fields. In the below screenshot, you can see three new columns using the New port button. Step 6: Now go to the normalizer tab and use the New field option to add new fields to the transformation. Step 5: The ports tab will have the input and output ports defined for the transformation. You can give an appropriate description of it and explain what the transformation is doing. Step 4: Now double click on the transformation, and you can make the necessary changes in it. Once you click on create the Normalizer transformation will appear on your mapping. Provide a unique name to this transformation and click on the create button.
Go to the Transformation tab and click on ‘Create’. Step 3: Once the mapping is ready, the next step is of creating the transformation.
0 kommentar(er)
