0 Replies Latest reply: Aug 29, 2012 1:20 PM by 953333 RSS

    Joining data files(tables) in Integrator

      I am building a graph in Integrator where I am reading data from multiple csv files. I could join them in two ways. Please explain which of following way is better from performance point of view.

      1. Use one ExtHashJoin component and provide input from all the csv files.

      2. Use one ExtHashJoin for every two inputs. e.g. Join Table 1 and 2 in first ExtHasJoin. Provide its o/p to next ExthasJoin component whose second input will be Table 3 and so on.

      Can someone shed some light on this.