Normalizing file structure

[sam93]

Hi,

I have a flat file with the following structure:
prod_category
prod_nbr1
prod_nbr2
prod_nbr3

Here is a sample record layout:
product_category prod_nbr1 prod_nbr2 prod_nbr3
a 1 2 3

How can I load data from this file to another flat file with the following normalized structure:
prod_category
prod_nbr

This would mean creating 3 records from the one above with the following layout:
prod_category prod_nbr
a 1
a 2
a 3

At the moment I am doing it by creating 3 instances of the target file in the mapping and loading a different product number in each of them while using the product category. Is there another way to do it?

Thanks.

 

[vln]

You can use a normalizer transformation as solution to ur problem.

Thanks