|
|
|
|
|
|
|
|
Re: Inserting data from multiple table into 1 table [message #661652 is a reply to message #661651] |
Mon, 27 March 2017 00:48 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Why loading into a stage table to then load into the target one?
Why this useless step?
You just move the problem from the target table to the stage one.
I provided a solution that guarantees the data are from the same point in time. An ETL will not guarantee this and so the data may not be consistent.
Another is to start a transaction in serializable mode and use INSERT SELECT for each source table.
(About the consistent point in time, I assumed there, and in the previous solution, that all tables are in the same database.)
|
|
|