Skip to main content

Minimizing sources

While Incentives calculation wizard does not restrict the number of sources that can be joined, increasing the number of sources also increases the complexity of calculation logic.

Recommendation for minimizing sources

  • Highly recommended to limit the number of data sources in any calculation to four or fewer.

  • Calculations requiring more than four data sources, consider splitting the calculation into smaller parts.

  • Limiting sources during the design phase is the most effective way to proactively mitigate potential calculation performance issues.

Exceptions

  • Exceptions can be made when the data sources have a low number of records (less than 100K).

  • Joins between these sources should ideally be on the primary keys to maintain performance.