below is my table definition

CREATE TABLE [dbo].[Factcalls]

(

[RowId] [varchar](15) NOT NULL,

[DimCustomerKey] [bigint] NOT NULL,

[CreatedDateKey] [bigint] NOT NULL,

[DimManpowerKey] [bigint] NOT NULL,

[ActivityKey] [bigint] NOT NULL,

[Time_Difference] [int] NOT NULL,

[Type] [int] NOT NULL,

[CreatedDateTS] [datetime2](7) NOT...

Thanks for the reply.

My dimension is having 5 billion records and 27 columns(apart from the columns I've given). If we change the relationship to 'flexible', will it affect the performance...