vinay

• Jul 24th, 2006

 

use a pre sql statement....but this is a hardcoding method...if you change the column names or put in extra columns in the flat file, you will have to change the insert statement

cholleti

• Jul 28th, 2006

 

hi vinay

    please can you be specific

shiridi

• Aug 6th, 2006

 

to the result set that's going to be loaded in to falt file..add a row with col names to that result set..either by pre sql or by joiner transformation..if ti wroks please let me know..thanks

shaik

• Aug 7th, 2006

 

please give in brief

Ravi

• Aug 9th, 2006

 

Hi,

          For getting the column names in the flat files, you need to make changes in the Informatica server setup. Under Informatica Server setup-> under configuration there is a option you need to check, Output Metadata for target flat files.

This should resolve your problem.

Thanks
Ravi.

jyothy

• Sep 12th, 2006

 

hi ,

please use normalizer transformation.

vick

• Sep 21st, 2006

 

In the warehouse , create the flat file  structure  and in source analyser create a source structure and follow the mapping process.

Mamatha

• Oct 24th, 2007

 

Hi,

   Create two file targets,the first target is loaded with the hardcoded column names and in the second file with actual values.In that particualr session there is a post session command in that we have merge the two file using unix cat command. so the format will be first row appears with all the column names and from second row it displays the actual values.

Regards
Mamatha

h02kkvel

 Profile Answers by h02kkvel 

• May 15th, 2008

 

Hi,
     the answers from ravi and mamatha are appriciated. 

some other friends told that by using pre sql .... but it is a flat file and how can we use a pre sql for flat file?

regards,
kiran

Sikindar

 Profile Answers by Sikindar 

• Mar 3rd, 2011

 

In case of target as a flat file, the header names will be defined during the target definition. The Header names can be specified using the option called 'Load Header' Option in Mapping tab of Session. There are three options 1. for no headers, 2. header from target definition and 3. Load from Command. based on these we can load the header names accordingly.

Rakesh

• Jul 28th, 2011

 

This is a way in informatica itself, follow the below step

In session level, click Edit - > Mapping - > select the tgt file - > goto Header Option -> select 'Output Filed Names'

We are done... u ll find the header names in the flat file. :)

cheers
Rakesh

Sumanth

• Aug 3rd, 2011

 

In session properties use the header option and select header output field name