|
|
Archives of the TeradataForum
Message Posted: Fri, 17 Apr 2015 @ 22:59:42 GMT
Subj: | | Re: Concurrent Insert/Select into Partitioned Table |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Friday, April 17, 2015 11:24 -->
Todd Walter wrote:
| 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. | |
Appreciate the response.
Are you indicating that as data for some group of Stores arrive we "build" a UNION statement comprising only those source tables manually and
then Insert/Select?
That option may not work as we are trying to build a fully automated process. Am I missing something here ?
Thanks.
| |