Forum Discussion
Parameters incremental refresh not found
Can you right click on the step and show me the code please?
select [_].[Asset_BW_ID] as [Asset_BW_ID],
[_].[Contract_FM_ID] as [Contract_FM_ID],
[_].[Asset_Serie] as [Asset_Serie],
[_].[Asset_Serie_Number] as [Asset_Serie_Number],
[_].[t0_0] as [Alarm_Date_Made],
[_].[Alarm_Time_Made] as [Alarm_Time_Made],
[_].[Alarm_Time_Made_Seconds] as [Alarm_Time_Made_Seconds],
[_].[Alarm_ReactionTime_Seconds] as [Alarm_ReactionTime_Seconds],
[_].[Alarm_ProcessingTime_Seconds] as [Alarm_ProcessingTime_Seconds],
[_].[Alarm_CompletionTime_Seconds] as [Alarm_CompletionTime_Seconds],
[_].[Alarm_Type] as [Alarm_Type],
[_].[Alarm_Prompt] as [Alarm_Prompt],
[_].[Alarm_Processor] as [Alarm_Processor],
[_].[Alarm_Country] as [Alarm_Country],
[_].[Country] as [Country],
[_].[Date_Staging] as [Date_Staging],
[_].[Date_DWH] as [Date_DWH],
[_].[Source_System] as [Source_System]
from
(
select [_].[Alarm_Key] as [Alarm_Key],
[_].[Date_Key] as [Date_Key],
[_].[Alarm_BKey] as [Alarm_BKey],
[_].[Asset_Key] as [Asset_Key],
[_].[Contract_Key] as [Contract_Key],
[_].[Date_BW_ID] as [Date_BW_ID],
[_].[Alarm_BW_Key] as [Alarm_BW_Key],
[_].[Asset_BW_ID] as [Asset_BW_ID],
[_].[Contract_FM_ID] as [Contract_FM_ID],
[_].[Asset_Serie] as [Asset_Serie],
[_].[Asset_Serie_Number] as [Asset_Serie_Number],
[_].[Alarm_Time_Made] as [Alarm_Time_Made],
[_].[Alarm_Time_Made_Seconds] as [Alarm_Time_Made_Seconds],
[_].[Alarm_DateTime] as [Alarm_DateTime],
[_].[Alarm_ReactionTime] as [Alarm_ReactionTime],
[_].[Alarm_ReactionTime_Seconds] as [Alarm_ReactionTime_Seconds],
[_].[Alarm_ProcessingTime] as [Alarm_ProcessingTime],
[_].[Alarm_ProcessingTime_Seconds] as [Alarm_ProcessingTime_Seconds],
[_].[Alarm_CompletionTime] as [Alarm_CompletionTime],
[_].[Alarm_CompletionTime_Seconds] as [Alarm_CompletionTime_Seconds],
[_].[Alarm_Type] as [Alarm_Type],
[_].[Alarm_Prompt] as [Alarm_Prompt],
[_].[Alarm_Processor] as [Alarm_Processor],
[_].[Alarm_Country] as [Alarm_Country],
[_].[Country] as [Country],
[_].[Date_Staging] as [Date_Staging],
[_].[Date_DWH] as [Date_DWH],
[_].[Source_System] as [Source_System],
convert(datetime2, [_].[Alarm_Date_Made]) as [t0_0]
from [dbo].[Fct_Alarm] as [_]
) as [_]
where [_].[t0_0] >= convert(datetime2, '2022-01-01 00:00:00') and [_].[t0_0] < convert(datetime2, '2030-12-31 00:00:00')