Hi Users,

Can any user tell me please difference between “Nth Field record identifiers, Starts at position record identifiers”

please can anybody help me to explane this…

Hi ,
We normally use 2 schemas.

Fixed Length Schema (where we specify the length of the entire record and the fields have limited charatcters length).

Delimited schema (where we use a delimiter to identify a records and fields).

Record identifier(Start at postion) is normally set when when we want to know from which character position the record reading should start .Here we make use of fixed length extractor while defining the flat file structure.

Record identifier(Nth Field ) is normally set when we want to know from which field(1st,2nd,3rd…Nth) the record reading should start.Here we make use of Nth field extractor while defining the flat file structure.

Please go through documentation for more details , hope this helps…!

Thanks,
Amol.

Thanks Amol But still have some doubt…

I have flat file →

Address+Delhi+India
Address+Pune+India

In Flat file Definition I have set

Delimiter–
Record = newLine
Field= +

Record Identifier:

Nth Field=0

and in Flat file Structure:

Address
City Extractor 1

its working fine when ever I have set the Record Identifier:

Nth Field=0 or Start at position=0

its working only these two are 0.
but when ever i am going to change it its not working saying Record not found…

Thats y i asked what is the use of these Identifier…

for getting the character position the record reading should start we have Extactor :Fixed Position…so what is the user of Start at position

I dont know what is the need of these can any one please let me know abhout this…I have read the document not still not clear…please can any one explane by example…