Re: Is modifying content in 'Data mart' possible for the applications quering it?
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 12 Mar 2010 16:01:51 +0100
Message-ID: <4b9a5772$0$22936$e4fe514c_at_news.xs4all.nl>
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'?
Date: Fri, 12 Mar 2010 16:01:51 +0100
Message-ID: <4b9a5772$0$22936$e4fe514c_at_news.xs4all.nl>
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