title: Azure data factory dataflow SELECT DISTINCT
body: <p>I have a dataflow with a few joins and when making the join #5, the number of row goes from 10,000 to 320,000 (to make an example of how the quantity is increased), but after that i have more joins to make so the dataflow is taking longer to complete.</p>
  <p>What I do is to add an Aggregate transformation after the joins, to groupby the field that I will use later, using that in a way that I use a SELECT DISTINCT in a query on the database, but still taking soooo long to finish.</p>
  <p>How can make this dataflow run faster?</p>
  <p>Should I use an Aggregate (and groupby the fields) between every join, to avoid the duplicates or just add the Aggregate (and groupby the fields...) after the join where the  rows starts to increase?</p>
  <p>Thanks.</p>