i am perfoming aggregation on certain columns and it throws me this warning and aborts ( does not show warning at which record but almost for all the records)
DIRECT_SALES_test_2006913..tf_ORDERTYPE: OCI has fetched truncated data
Size of the table 8Million
My aggregation is through SQL query
SELECT ORDER_ID,MATERIAL,
SUM(SALES_SALES),
SUM(SALES_QNTY),
AVG(SALES_UNIT),
SUM(RETURN_SALES),
SUM(RETURN_QNTY),
AVG(RETURN_UNIT),
SUM(CREDITMEMO_SALES),
SUM(CREDITMEMO_QNTY),
AVG(CREDITMEMO_UNIT),
SUM(SAMPLES_SALES),
SUM(SAMPLES_QNTY),
AVG(SAMPLES_UNIT) FROM DIRECT_SALES_STG_01
GROUP BY ORDER_ID,MATERIAL
If i use Aggregator stage it throws this error
DataStage Job 823 Phantom 3236
Program "DSP.ActiveRun": Line 51, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage DIRECT_SALES_test_2006913..Aggregator_15
DataStage Phantom Aborting with @ABORT.CODE = 3
Please help me on this
![Sad :(](./images/smilies/icon_sad.gif)
thanks
paddu