This discussion is archived
0 Replies Latest reply: Aug 29, 2012 11:20 AM by 953333 RSS

Joining data files(tables) in Integrator

953333 Newbie
Currently Being Moderated
Hello,
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.

Thanks,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points