Skip to Content
0
Former Member
Jun 12, 2009 at 06:27 AM

Problem in Loading TB

61 Views

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...