Help Understanding Aggregation Awareness

Hi brussom ,
Based on your description, first, make sure that in the Manage Aggregates dialog box, the aggregation settings for the NumbersUnder1k table correctly use the COUNT function. Double-check that the Aggregation Type is set to Count instead of Sum, and verify that the property for column N in the NumbersImport_Agg table is set to Do Not Summarize. Sometimes, the default summary settings may override the aggregation function. Then, make sure that the NumbersImport_Agg table is set up correctly as an aggregation table. If there is a difference in the table settings, the mapping may not recognize it correctly.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly