Normalizer Tr

[kpmINFO]

if I get data from same source qualifier and branched into two, can I use normalizer tr to combine them again.
Here is the scenario

My source is a flat file, it has a one line header and body has more than one line
header has a date field , I would like to compare the date field in the header with a fields in body.Below is a prototype of my mapping

source--> source qual-->Filter tr--> Header data
Body data

If I split my data into two streams, header has only one line and body has more than one line
If I want to add a new port in the body data and add date field that is in the header to the body data, can I use a Normalizer tr, if yes how, if not what would be the best way??

 

[blom0344]

Hmmm,

Are you sure that you want a normalizer in the first place?
Secondly, why try and store header and body data the way you do? If you are populating a database you do not want to store separate header data within the same table.

My advice would be to store the header-data in a seperate table and then use a lookup from the mapping that handles the body-data to that header table.

Add a port in the body-mapping with a constant value that m,atches a column-value in the header-table and you lookup from every row from the body-mapping.

T. Blom
Information analyst
tbl@shimano-eu.com