If the combination on Source Name, Stage Name, Stage Table Name, DWH Name and DWH Table name get too long one of our customers get the below
The identifier that starts with 'DM_Eng Lee Stage_Eng Lee_dbo_Eng Lee_Option_Insurance Calculation_Policy Sub Type_EngLeegGroupDWH_dbo_Insurance Cal_Policy Sub T' is too long. Maximum length is 128.
Since all tables now have the extended property "TX Guid" would it be possible to name the DM view something like DM_<GUID_StageTable>_<GUID DWH Table> to eliminate customers running into this problem?
It makes debugging a little for difficult but would eliminate the above problem.