on 12-10-2008 1:43 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.