The transformation file created is this..
*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = TAB
SKIP = 1
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=500
ROUNDAMOUNT=
*MAPPING
DATASRC = *NEWCOL(INPUT)
INTCOL = *NEWCOL(FSL_NO_INT)
APPLICATION = *NEWCOL(LEGALAPP)
ACCTDETAIL = *NEWCOL(F_ERR)
CATEGORY = *NEWCOL(ACTUAL)
GROUPS = *NEWCOL(LC)
MEASURES = *NEWCOL(PERIODIC)
LEGALENTITY = *COL(1)
ACCOUNTL = *COL(2)
TIME = *COL(3)
SIGNEDDATA=*COL(4)
and data load file is saved in txt format tab delimited with the following records
entity gl codes time amount
7100 13122358 2009.JAN -9943438.66
7100 13120253 2009.JAN -641062
while validating the transformation file with the data file, we get the following error
[Start validating transformation file]
Validating transformation file format
Validating options...
Validation on options was successful.
Validating mappings...
Validation on mappings was successful.
Validating conversions...
Validation on conversions was successful.
Creating the transformation xml file. Please wait ...
Transformation xml file saved successfully.
Connecting to server ...
Begin validate transformation file with data file...
[Start test transformation file]
Validation with data file failed.
VALIDATE_RECORD Option =
Please advise if the data mapping, file loading format etc is correct..if yes then why do we get this error...