How u will create header and footer in target using informatica?

Showing Answers 1 - 4 of 4 Answers

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?

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

lakshmi

  • Nov 7th, 2012
 

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

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions