1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
insert into [teste].[anissql].[Fact_Log]
(ID_log,Outcode,Outmsg,F_success,ID_client,ID_WS,ID_agent,ID_Date,ID_WF)
SELECT [Log_Reclamation].[dbo].[FICHER_LOG].ID_log ,[Log_Reclamation].[dbo].[FICHER_LOG].Outcode,[Log_Reclamation].[dbo].[FICHER_LOG].Outmsg,[Log_Reclamation].[dbo].[FICHER_LOG].F_success,[teste].[anissql].[Dim_Client].[ID_client],[teste].[anissql].[Dim__Web_Service].[ID_WS],[teste].[anissql].[Dim_Agent].[ID_agent],[teste].[anissql].[Dim_Date].[ID_Date],[teste].[anissql].[Dim_Workflow].[ID_WF]
FROM [Log_Reclamation].[dbo].[FICHER_LOG], [teste].[anissql].[Fact_Log] join [teste].[anissql].[Dim_Client]
on [teste].[anissql].[Fact_Log].[ID_client] = [teste].[anissql].[Dim_Client].[ID_client]
join [teste].[anissql].[Dim__Web_Service]
on [teste].[anissql].[Fact_Log].ID_WF=[teste].[anissql].[Dim__Web_Service].ID_WS
join[teste].[anissql].[Dim_Agent]
on [teste].[anissql].[Fact_Log].ID_Agent=[teste].[anissql].[Dim_Agent] .ID_agent
join [teste].[anissql].[Dim_Date]
on [teste].[anissql].[Fact_Log].ID_Date=[teste].[anissql].[Dim_Date].ID_Date
join [teste].[anissql].[Dim_Workflow]
on [teste].[anissql].[Fact_Log].ID_WF=[teste].[anissql].[Dim_Workflow].ID_WF |
Partager