Archives of the TeradataForum

Message Posted: Wed, 15 Apr 2015 @ 17:45:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If you know that they have all arrived, or some group have arrived, you can build a UNION for the source of the INSERT SELECT for the ones that are available. The INSERT SELECT will then insert the whole result of the UNION in one insert process.

It sounds like the staging tables are fairly small though. When they are small, individual insert selects will run quite quickly and it will be a similar time to get the job done if you just launch them when the data for that store is avalable and allow them to sequence through.

	<Prev	Next>		<<First	<Prev	Next>	Last>>