is it better to SimpleCopy of use multiple output ports

bradrust

• November 15, 2007 00:00

• Answered

Follow

I have an input csv which feeds eventually into 10 different tables. Is it better (efficient) to have 10 output ports from the DelimitedReader or to have a SimpleCopy node to split the records for insertion into DB_OUTPUT_TABLE nodes?

Along these lines, if I have to set phases on the DB_OUTPUT_TABLE nodes to manage some FK constraints, does the matter in which I read/copy the input data matter across Phases?

Thanks,
Brad

• 

  avackova

  • November 19, 2007 10:15

  0

  Comment actions Permalink

  Hello,
  if all tables have the same metadata it is faster to have more output ports then SimpleCopy node. On DBOutputTable you can set phases as you want not depending on order of output ports on prior node.

Please sign in to leave a comment.