sys_dwh
Description
-
contains only synonyms to connect a repository database and a dwh database
-
connect repo datatabase to dwh database using synonyms executing the stored procedure config.usp_connect_database - P
Example 1. connect repository database to the dwh database 'WideWorldImporters'EXEC [config].[usp_connect_database] @dwh_database_name = 'WideWorldImporters'