Re: How to change ETL layer dynamically?
From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Wed, 24 Mar 2010 14:44:25 +1100
Message-ID: <MPG.261435a1fc649d969897d7_at_news.x-privat.org>
In article <eed0e313-0f02-4a83-ba87-1623c9045ab3_at_ 19g2000yqu.googlegroups.com>, guser78 says...
> We have to create a Datamart containing the Customer characteristics
> like 'Heavy Buyer; Chocolate lover' etc., and this has to be done by
> evaluating the relevant attributes in the Data ware house tables.
> But, in our case, the definition of Customer characteristics can
> change occasionally based on the new market conditions.
>
> This means that we should allow the dynamic administration of the
> definition of Customer characteristics.
>
> Please guide me on we can do this from an Application which uses the
> Datamart as the backend. Do we need to write an additional software
> module (for e.g. JDBC) to interpret the 'write' requests coming from
> the Application, and adapt the ETL layer accordingly?
Date: Wed, 24 Mar 2010 14:44:25 +1100
Message-ID: <MPG.261435a1fc649d969897d7_at_news.x-privat.org>
In article <eed0e313-0f02-4a83-ba87-1623c9045ab3_at_ 19g2000yqu.googlegroups.com>, guser78 says...
> We have to create a Datamart containing the Customer characteristics
> like 'Heavy Buyer; Chocolate lover' etc., and this has to be done by
> evaluating the relevant attributes in the Data ware house tables.
> But, in our case, the definition of Customer characteristics can
> change occasionally based on the new market conditions.
>
> This means that we should allow the dynamic administration of the
> definition of Customer characteristics.
>
> Please guide me on we can do this from an Application which uses the
> Datamart as the backend. Do we need to write an additional software
> module (for e.g. JDBC) to interpret the 'write' requests coming from
> the Application, and adapt the ETL layer accordingly?
Google: "slowly changing dimensions"
GM Received on Tue Mar 23 2010 - 22:44:25 CDT