If we have a fixed width Flat file, we can read it via Sequential File stage only, no need to use Import Stage. For reading a Fixed Width Flat file, you should know the format of Fixed width data. How are the data splitting into two or more output columns.
Here, I demonstrate How to read a Fixed Width Flat file from Sequential File Stage
A. Input File :
Below is the Input file which we are going to use in our job. This file contains a column RollNo which is concatenation of 4 fixed width columns which we have to split and read.
B. Design :
Below Job design demonstrate the logic where we are reading a fixed width file via 'seq file stage', Copy stage or other stage if any processing want to do and the target file.
This is what you have to define in your Input Seq File properties :
At Record Level :-
Final delimiter - end
Record delimiter - Unix NewLine ( the char which is splitting the Record )
Record length - fixed
At Field Level :-
Delimiter - none ( as no delimiter is there in input data)
Quote - none
D. Input Metata
Now, define the input metadata as needed. In this example we are using below -
Metadata should be defined as CHAR with LENGTH ( No VARCHAR ).
E. Output File Properties :-In Output, we are using a seq file, This is what I have defined for this job.
F. Output File
This is How you can see the Output after successfully run of this job.
Like the Facebook Page & join Group
For WHATSAPP group , drop a msg to 91-88-00-906098