Archives of the TeradataForum
Message Posted: Wed, 15 Apr 2015 @ 14:22:37 GMT
<-- Anonymously Posted: Tuesday, April 14, 2015 15:52 -->
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|