effect of data sources in dimensional modeling
4 posters
Page 1 of 1
effect of data sources in dimensional modeling
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?
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
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: effect of data sources in dimensional modeling
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.
If you don't have data suitable for the model, change the model.
Re: effect of data sources in dimensional modeling
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?
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
Re: effect of data sources in dimensional modeling
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
marcin.wizgird- Posts : 4
Join date : 2013-05-07
Re: effect of data sources in dimensional modeling
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?
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
Reply with quote Re: effect of data sources in dimensional modeling
True.
In the global data warehouses of my clients it's normal practice.
In the global data warehouses of my clients it's normal practice.
marcin.wizgird- Posts : 4
Join date : 2013-05-07
Re: effect of data sources in dimensional modeling
thanks so mush.
I found my answer...
I found my answer...
fahime- Posts : 8
Join date : 2013-11-14
Similar topics
» 2 sources using Dimensional Modeling Workbook
» Data Modeling question (not really dimensional though)
» Multiple sources for the same data - which one to extract from?
» Dimensional data modeling CASE tool and DW design practice
» Data Modeling question (not really dimensional though)
» Multiple sources for the same data - which one to extract from?
» Dimensional data modeling CASE tool and DW design practice
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum