Repeat Header File information for all records

[bampi777]

I am using Informatica Power center 9. I have a flat file with about 100 rows which I would load into an another flat file as output. I have the first row in the flat file with just one date value in the entire row. All the other 99 rows have data.

I need to load the 99 rows into the target flat file and the header date value should be repeated for all the 99 rows as an extra column.

How can I achieve this ? Please suggest.

 

[rasETL]

bampi777

I suggest using a Router Transformation.

Send the one/first record with the date to one "stream", all other records to another stream. Then, concatenate the date before the flat file target.

You need to determine a column that can be used to determine which "stream" to take.

Hope that helps.