effect of data sources in dimensional modeling

View previous topic View next topic Go down

effect of data sources in dimensional modeling

Post  fahime on Thu Nov 14, 2013 3:01 am

Hello
Is it possible to remove something from dimensional model because there is not anything about it in data sources?
for example :best dimensional model is based on REAL data that determine with business process
now if I want to fill a dimension table  that not have anything in data sources for it ,how can I fill it in ETL process?

fahime

Posts : 8
Join date : 2013-11-14

View user profile

Back to top Go down

Re: effect of data sources in dimensional modeling

Post  BoxesAndLines on Thu Nov 14, 2013 10:40 am

Make it up?
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: effect of data sources in dimensional modeling

Post  ngalemmo on Thu Nov 14, 2013 12:31 pm

I don't follow. Are you talking about a packaged 'standard' data model?

If you don't have data suitable for the model, change the model.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: effect of data sources in dimensional modeling

Post  fahime on Fri Nov 15, 2013 7:07 am

for example I want to store customer age in customer dimension table,
but in all data sources that I can use there is not anything about customer age.
what can I do?

fahime

Posts : 8
Join date : 2013-11-14

View user profile

Back to top Go down

Re: effect of data sources in dimensional modeling

Post  marcin.wizgird on Fri Nov 15, 2013 7:30 am

Sometimes dimension attributes such as customer age can be calculated in the ETL process. In case it's not possible and they cannot be sourced from any source, they can be manually edited by business users - for instance with special web application dedicated for that purpose
avatar
marcin.wizgird

Posts : 4
Join date : 2013-05-07

View user profile

Back to top Go down

Re: effect of data sources in dimensional modeling

Post  fahime on Fri Nov 15, 2013 7:42 am

ok, thanks.
therefore, not only data warehouse tables data fill with data sources in ETL process,but also business users can change data warehouse tables data with some applications, for example web applications.
is it true?

fahime

Posts : 8
Join date : 2013-11-14

View user profile

Back to top Go down

Reply with quote Re: effect of data sources in dimensional modeling

Post  marcin.wizgird on Fri Nov 15, 2013 7:50 am

True.
In the global data warehouses of my clients it's normal practice.
avatar
marcin.wizgird

Posts : 4
Join date : 2013-05-07

View user profile

Back to top Go down

Re: effect of data sources in dimensional modeling

Post  fahime on Fri Nov 15, 2013 7:52 am

thanks so mush.
I found my answer...

fahime

Posts : 8
Join date : 2013-11-14

View user profile

Back to top Go down

Re: effect of data sources in dimensional modeling

Post  Sponsored content


Sponsored content


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