Skip to Content
0
Nov 08, 2012 at 11:16 AM

issue in validating and transforming flat file

34 Views

Hi,

I have been facing issue in validating and transforming flat file.

I am getting error " All records are rejected".

here are details.

*OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER = TAB AMOUNTDECIMALPOINT = . SKIP = 0 SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE= NO MAXREJECTCOUNT= ROUNDAMOUNT= *MAPPING C_ACCT = *COL(1) INTCO = *Str(I_NONE) Entity = *Str(DHI) Time = *COL(4) Flow = *Str(F_100) C_DATASRC = *COL(6) RptCurrency = *Str(BTN) CONSGROUP = *Str(G_DHI) C_CATEGORY = *Str(C_100) AMOUNT = *COL(10) *CONVERSION ENTITY= LEGENT.XLS

Earlier I had duplicate records in ACCOUNT column which I have removed but still I am getting this error.

More over, it is really bugging that it doesn't show where it is going wrong or doesn't throws specific error message.

It is not processing even single records so I am sharing first 10 records with header, so that it you can give your insight.

Account INTCO Entity Time Flow DATASRC RptCurrency CONSGROUP C_CATEGORY Amount 11092030 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 30000 11092110 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 6.29E+08 11111010 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 1572885 11111060 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 79300 12031030 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 41975600 12120000 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 6135046 12133000 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 5769021 12133020 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 -1850331 21033000 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 -64814 21034000 I_NONE DHI 2010.DEC F_100 INPUT BTN G_DHI C_100 -2.1E+07

Error details is mention herewith.

[Start validating transformation file]

Validating format of transformation file

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; wait a moment

Transformation xml file saved successfully

Connecting to server...

Begin validate transformation file with data file…

[Start test transformation file]

Validate has successfully completed

ValidateRecords = YES

[List of conversion file]

Conversion file: DataManager\ConversionFiles\LEGENT.XLS!CONVERSION

Record count: 91

Accept count: 0

Reject count: 91

Skip count: 0

Error: All records are rejected

Looking forward for your positive reply.

Regards,

Paresh