How to change ETL layer dynamically?

From: guser78 <qazmlp1209_at_rediffmail.com>
Date: Tue, 23 Mar 2010 04:03:29 -0700 (PDT)
Message-ID: <eed0e313-0f02-4a83-ba87-1623c9045ab3_at_19g2000yqu.googlegroups.com>

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? Received on Tue Mar 23 2010 - 06:03:29 CDT