CODEWITHSUNDEEP
informatica
Dozel
Dozel

Reputation: 159

Informatica csv output contains # in front of the first column name

the output pdo is a flat file type with comma delimited. After running the mapping, there's a '#' in front of the first column name in the csv output file.

Here's my settings for the pdo: Run-time write: Header options: output field names

Upvotes: 1

Views: 859

Answers (1)

Koushik Roy
Koushik Roy

Reputation: 7407

Assuming your infa version is higher than PowerCenter 9.1.0 Hot Fix4, you can easily remove from the hash from the flat file header. Set the RemoveOutputHeaderHash = Yes under the custom properties of the session.

If you want to apply globally, you can add it to Integration Service.​

Upvotes: 1

Related Questions