Is it better to SimpleCopy of use multiple output ports

CloverDX Platform
1

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

2

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.