CODEWITHSUNDEEP
csvinformaticainformatica-powercenterflat-file
Ayush Kesarwani
Ayush Kesarwani

Reputation: 530

Informatica PowerCenter Designer: Skip 1st column from flat file

I have a flat file in CSV format. In that, I have 5 different columns. The 1st-row is the header. I want to Skip 1st column while importing the flat file as a source from Informatica PowerCenter Designer and only read data from rest of the 4 columns. How do I achieve this?

Note: I know, I can just import 1st column and don't map it and remove that port from Source Qualifier Transformation. Also, I don't want to remove the 1st column from my CSV flat file.

Is there any way to do this?

Upvotes: 0

Views: 1782

Answers (1)

Daniel Machet
Daniel Machet

Reputation: 630

There is no way to do what you're asking (and no meaningful reason to do it either that I can discern). Now if its rows you want to skip then thats another matter

Upvotes: 1

Related Questions