Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 15 Apr 2015 @ 14:22:37 GMT

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

Subj:   Re: Concurrent Insert/Select into Partitioned Table
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, April 14, 2015 15:52 -->

Hi Dave,

Thank you for explaining this clearly. I apologize for the delay in responding as I have been busy.

To answer your question-

We have multiple Staging databases for each store with the same tables/structures. However, there is only one target database. The aim is to load to a particular table in the target database simultaneously from each of its corresponding tables from each of the Staging databases (for every store).

For e.g. For Store-X there exist a Staging db DB_X with a table Customer. Similarly, for store-Y we have DB_Y which also has a table Customer and so on. There are currently 283 stores. There is only on target database TGT_DB which has a customer table. The data needs to flow from DB_X.Customer, DB_Y.Customer, etc to TGT_DB.Customer concurrently.

The data may arrive in the staging database for the stores simultaneously so the user wants the data to get loaded into the target table concurrently (for every available store) so that the reports which runs on top of the target table can "see" the most current data for all the stores collectively.

How can this be achieved ?

Thanks in advance...

  <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: 15 Jun 2023