How to skip header record and read only data records in a flat file in Informatica BDM

Skip the header record and read only data records in a delimited file in Informatica BDM

If you have a comma separated delimited file with a header record, by default informatica will read all records and process it. If you want to skip the header records and read only data records, give the "start import at line" value as "No of header records". 

In the below example since I have only 1 header record, i have updated the configuration as "start import at line=1". If you have more number of header records, you can set the value accordingly. 

comma separated file (.csv) with 1 header record!

 

By default informatica will read all records including header!

 

Modified the configuration to start import at line 1 to skip the header record!

 

Liked the content??
Please Like FB page & subscribe the channel!
Let's learn together!

Need Help? email me

Search tags

  • Skip the header record and read only data records in a delimited file in Informatica BDM
  • How to Skip 1 or more header rows with Flat file Informatica BDM
  • How to remove header records from a flat file in Informatica BDM
  • How to skip the first record in the flat file in Informatica BDM