AXISHK
asked on
Make Year, Period in Fact table as a dimension key attribute
Is it possible to make the year and Period in my Fact table as a dimension key attribute ? My current Fact table scheme is :
REATE TABLE [dbo].[FactPERBAL](
[TRXNO] [int] IDENTITY(1,1) NOT NULL,
[ACTKEY] [int],
[ACTINDX] [int] NOT NULL,
[ACTNUMBR_1] [char](11) NOT NULL,
[YEAR1] [smallint] NOT NULL,
[PERIODID] [smallint] NOT NULL,
[PERDBLNC] [numeric](19, 5) NOT NULL,
[CRDTAMNT] [numeric](19, 5) NOT NULL,
[DEBITAMT] [numeric](19, 5) NOT NULL,
CONSTRAINT [PK_FactPERBAL] PRIMARY KEY NONCLUSTERED
(
[TRXNO] ASC
))
REATE TABLE [dbo].[FactPERBAL](
[TRXNO] [int] IDENTITY(1,1) NOT NULL,
[ACTKEY] [int],
[ACTINDX] [int] NOT NULL,
[ACTNUMBR_1] [char](11) NOT NULL,
[YEAR1] [smallint] NOT NULL,
[PERIODID] [smallint] NOT NULL,
[PERDBLNC] [numeric](19, 5) NOT NULL,
[CRDTAMNT] [numeric](19, 5) NOT NULL,
[DEBITAMT] [numeric](19, 5) NOT NULL,
CONSTRAINT [PK_FactPERBAL] PRIMARY KEY NONCLUSTERED
(
[TRXNO] ASC
))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER