Transaction level granularity

View previous topic View next topic Go down

Transaction level granularity

Post  sirmhb on Tue Nov 12, 2013 8:48 am

Hi
I have a fact table which it contains transaction information like "Transaction Amount" ,"Transaction date and time" , "Transaction ID" and etc
"Transaction ID" is primary key of fact table.I need transaction level granularity.
Can I use Fact table Primary key ("Transaction ID") as a Dimension?
If not how should I design my data warehouse so I can have transaction level granularity?
Regards

sirmhb

Posts : 1
Join date : 2013-11-12

View user profile

Back to top Go down

Re: Transaction level granularity

Post  ngalemmo on Tue Nov 12, 2013 11:53 am

Transaction ID can be a degenerate dimension value in a fact table.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum