SQL Server synonyms with concurrent execution -


I work in a DW project where we do ETL using T-SQL with STL Server 2012. Our code works well for so long A set of tables coming from the heritage system However, the data architect has announced that we will get tables from other heritage systems. He wants only one piece of code to be able to handle all the tables in all systems because they have the same structure but are present in different DBs in the same server.

On that, the existing system code must be run for all system tables at the same time so that we can save execution time. I am working on a POC which uses the synonyms that do the trick but it will not execute our codes for different sets of tables at the same time because we end up with references to synonyms that end in Overwrite. So now I am reconsiding the whole problem: How to avoid repeating the same code for repeating tables at the same time? Any insights or suggestions would be appreciated thanks.

I will consider using SSIS to do my ETL. You can change the location of the source data at the time of the run and should work until the structure is the same.


Comments

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

eclipse plugin - Run java code error: Workspace is closed -

c - Error on building source code in VC 6 -