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.XLSEarlier 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+07Error 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