Interventions: //Want to join this to the fact table for below calculation to work LOAD "Interventions_ID", "Interventions_Types" AS [Interventions]; SQL SELECT "Interventions_ID", "Interventions_Types" FROM "NCPMH_COPY_2".dbo."Dim_Interventions";
Intervention ID will not be there in Fact table as it is coming from Interventions table, you have to join Fact and Interventions table and then you can load from that. and also i want to know what type of data will be there in Interventions table ? to check that is it possible to handle by writing some script logic.