Submit Count less than Record Count

[Former Member]

When I run an import package, my submit count is less than record count? Any idea why?

e.g.:

TOTAL STEPS 2

1. Convert Data: completed in 523 sec.

2. LOAD AND PROCESS: completed in 973 sec.

[Selection]

-

---

FILE=\TMobile\CAPEX\DataManager\DataFiles
CAPEX-Data-Scrubbed-Jan2008-Nov2008-12-09-2008.txt

TRANSFORMATION=\TMobile\CAPEX\DataManager\TransformationFiles
CAPEX TRANSFORMATION.xls

CLEARDATA= No

RUNLOGIC= No

CHECKLCK= No

[Messages]

-

---

CAPEX

Success

Submit Count : 712473 (Record count in source file : 744298)

Accept Count : 712473

Reject Count : 0

[Former Member · Accepted solution]

Hi,

I believe some records might have aggregated. Please check the data file which you have uploaded. Additionally check your transformation file once again as there is some kind of processing also involved.

Hope this helps. Kindly reciprocate by awarding points.

[sorin_radulescu]

Yes some records are aggregated if they have the same dimensions or some values into database are equal with value which you want to import and in that case that records are skipped.

Regards

Sorin Radulescu