Thursday, March 29, 2012

ETL - cancel changes and going back to a previous state

On Dec 18 2006, 9:43 pm, "Chris Le Roquais"
<christophe.leroqu...@.gmail.com> wrote:
> Hi there,
> I would like to know if this is a usual practice to having an ETL able to
> cancel (rollback) the move of data that has been done into a destination.
> In other words, after having inserted data into a destination, can we go
> back to a previous state?
> Is that common to do that? How to do that? What do we need to consider
> before implementing such a feature? What tools/solutions are available to
> activate this feature?
> I personaly use MS SSIS as an ETL tool
> Thanks,
>
Christophe,
Common practice (See Kimball DW Toolkit) is to maintain an audit table
in the datawarehouse. Each row inserted/updated in the datawarehouse
is then assigned an AuditKey such that all records associated with a
Load can be identified.
Rgds,
Garrett
I'm just guessing here - but I would imagine SCD transforms would be
difficult to rollback - but not identify.
<garrett.fitzsimons@.gmail.com> wrote in message
news:1170776521.710994.166840@.m58g2000cwm.googlegr oups.com...
> On Dec 18 2006, 9:43 pm, "Chris Le Roquais"
> <christophe.leroqu...@.gmail.com> wrote:
> Christophe,
> Common practice (See Kimball DW Toolkit) is to maintain an audit table
> in the datawarehouse. Each row inserted/updated in the datawarehouse
> is then assigned an AuditKey such that all records associated with a
> Load can be identified.
> Rgds,
> Garrett
>
>

No comments:

Post a Comment