Re: Is modifying content in 'Data mart' possible for the applications quering it?

From: Shakespeare <>
Date: Fri, 12 Mar 2010 16:01:51 +0100
Message-ID: <4b9a5772$0$22936$>

Op 12-3-2010 14:34, guser78 schreef:
> I would like to know whether the content of the 'Data mart' tables be
> modified by the Marketing applications.
> I understand that the 'Data mart' is filled by the ETL layer by
> extracting and transforming the data from the Data warehouse(for
> 'Dependent datamart' case).
> After it is filled, does the Marketing application have the option of
> only 'read'/'query'ing the data from the 'Data mart'? In our usecase,
> there is a specific case where the applications need to write some
> minor data occasionally into the Data mart (into the existing tables,
> not in any new tables). Is that Technically feasible with the 'Oracle
> Data mart'?

Sure, why not? As long as you realize that all changes may be lost when a new ETL process has run.

Shakespeare Received on Fri Mar 12 2010 - 09:01:51 CST

Original text of this message