Skip to Content
0
Former Member
Jan 02, 2008 at 09:44 AM

Problem with FCC

25 Views

Hi,

I have 3 records Rec_A, Rec_B, Rec_C_D and each of this record having common strcuture of fields but with different occurances.

Rec_A -- EMPNO 1:1

JNDate 0:1

Dept 1:1

Rec_B -- EMPNO 1:1

JNDate 1:1

Dept 1:1

Rec_C_D -- EMPNO 1:1

JNDate 0:1

Dept 1:1

It is a Asterik(*) separated delimited file and end separator is New Line.

Depending on the Dept field, the record has to processed.

Ex: If the Dept value is C, then it has to process Rec_C_D and if Dept value is B, it has to process Rec_B Vice versa.

In Configuration I specified the FCC Parameters as follows :

*KeyFieldName : Dept*

Rec_A.fieldSeparator : *

Rec_A.endSeparatot : 'nl'

Rec_A.fieldNames: EMPNO,JNDate,Dept

Rec_A.keyFieldName: A

Similarly defined for Rec_B and Rec_C_D as well.

I gave my input file as follows :

12320080102A

345* *B

789* *A

14320080102C

Its reading only the two records ( First and last one) as I gave all the three fields in the input file.

If I miss any of the filed (although it is optional) its not processing that record.

Please give me some pointers to overcome this issue.

Regards,

Babu