question

Raj More avatar image
Raj More asked

The number of key combinations is more than expected

We are building a warehouse using SSIS. I am doing an aggregation and I received the following message `The Aggregate transformation has encountered 2000037 key combinations. It has to re-hash data because the number of key combinations is more than expected. The component can be configured to avoid data re-hash by adjusting the Keys, KeyScale, and AutoExtendFactor properties` It did not write the output, and **most disturbingly**, it did not throw any exceptions. What is going on here? How do I fix this?
ssissql-server-2008-r2aggregates
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.