Multiple source file with different measures
3 posters
Page 1 of 1
Multiple source file with different measures
Hi,
I scanned briefly for my scenario in the forum but couldn't find much.
We get 10 source files containing a list of measure at point of time (DateTime) daily.
Each files have different activity measurements, 40% of the measures are common for 5 source files, 20% for other 3 files and so on...
I am leaning to have a 1 big merged fact table with all measures from all the files and a additional field Activity_Type to identify Activity Type.
We don't have future reporting anticipation but hoping requirement will be to report measurement independent of Activity_Type which would mean "WHERE Activity_Type = 'ABC' AND DATE = 'xx' AND ...."
Would anyone see any drawback in this approach.
Sarah
I scanned briefly for my scenario in the forum but couldn't find much.
We get 10 source files containing a list of measure at point of time (DateTime) daily.
Each files have different activity measurements, 40% of the measures are common for 5 source files, 20% for other 3 files and so on...
I am leaning to have a 1 big merged fact table with all measures from all the files and a additional field Activity_Type to identify Activity Type.
We don't have future reporting anticipation but hoping requirement will be to report measurement independent of Activity_Type which would mean "WHERE Activity_Type = 'ABC' AND DATE = 'xx' AND ...."
Would anyone see any drawback in this approach.
Sarah
sarah_id1- Posts : 9
Join date : 2010-11-18
Re:Multiple source file with different measures
Hi,
It looks fine, if you don't have any reporting requirement. Are all the different activity measurement coming at the same frequency or some are coming daily and some are at a different frequency (the grain) ?
thanks
It looks fine, if you don't have any reporting requirement. Are all the different activity measurement coming at the same frequency or some are coming daily and some are at a different frequency (the grain) ?
thanks
hkandpal- Posts : 113
Join date : 2010-08-16
Multiple source file with different measures
You should at least create a "source" dim so you know which measure is coming from where.
zoom- Posts : 97
Join date : 2010-08-23
Location : Chicago
Similar topics
» multiple currencies for measures in Fact Table
» Multiple measures in a fact table- modelling question
» How to handle multiple aggregations for multiple KPIs in fact table
» ETL Architecture and Control Flow
» multiple hierarchy : single dimension vs multiple
» Multiple measures in a fact table- modelling question
» How to handle multiple aggregations for multiple KPIs in fact table
» ETL Architecture and Control Flow
» multiple hierarchy : single dimension vs multiple
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum