UmaBojja

• Jun 13th, 2006

 

If you are focus is about the flat files then one can set it in file properties while creating a mapping or at the session level in session properties

Thanks

Uma

kareemuddin ahmed

• Jun 24th, 2006

 

hi uma,

thanks for the answer, i want the complete explanation regarding to this question how to create header and footer in target?

varun joshi

• Aug 7th, 2006

 

you can always create a header and a trailer in the target file using an aggregator transformation.

Take the number of records as count in the aggregator transformation.

create three separate files in a single pipeline.

One will be your header and other will be your trailer coming from aggregator.

The third will be your main file.

Concatenate the header and the main file in post session command usnig shell script.

lakshmi

• Nov 7th, 2012

 

Hi..
As uma told...she is rite,but may i know how to create footer in a flatfile

Ruhi

• Feb 4th, 2016

 

The header or footer can be created in the target using the property "append if exist"
Depending on what you need in the header / footer and target data create our mapping. Example 3 flows of data
Source -> transformation for header -> target.txt
Source -> transformation for target data -> target.txt
Source -> transformation for footer -> target.text

Set the target load order as above order and set the target file names as same

Go to session and in properties set file property to APPEND IF EXISTS.

This will append the data in the order specified in target with header, footer