Data engineering and IT

Fan trap

  • Data engineering and IT

Definition

When joining to a table with more rows per key multiplies your results, so totals are counted several times.

For your role

Choose your role to see what this term means in your work.

Why it matters

Where it is used

Any query joining orders to order lines, which is where most double-counting starts.