Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 17 Apr 2015 @ 22:59:42 GMT

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

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 ?


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020