Time dimension
Page 1 of 1
Time dimension
With courses and registration, I was curious. With the ETL would have a time dimension foreign key written to the fact table, and then the next day load it based on the sysdate, meaning, you get a record for each day that it runs? or just the time of the event itself?
chade25- Posts : 29
Join date : 2012-04-12
Age : 44
Location : Oregon
Similar topics
» Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
» Time dimension design for cross time zone and custom calendar warehouse, 1min granularity
» Time Dimension, NULLs and Time datatype
» time dimension
» Time of Day Dimension
» Time dimension design for cross time zone and custom calendar warehouse, 1min granularity
» Time Dimension, NULLs and Time datatype
» time dimension
» Time of Day Dimension
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|