How to Skip first COLOUMN from a flatfile and load remaining columns using mload?

Database
Enthusiast

How to Skip first COLOUMN from a flatfile and load remaining columns using mload?

Hi Experts,

How

I have an urgent requirement. I need to skip first column from a delimited flat file and load remaining coloumns to my traget table..

Is there any property to skip first COLUMN?

Please suggest.

Thanks

Amarnath

1 REPLY
Senior Apprentice

Re: How to Skip first COLOUMN from a flatfile and load remaining columns using mload?

Hi Amarnath,

simply define it as a FILLER instead of a FIELD in the LAYOUT.