Staging Tables and Envers

tcanavan Aug 3, 2011 3:05 AM

We are looking at using envers to populate staging tables for a datawarehouse.

When an entity needs to be split into more than one staging table is ther a way in Envers to do this.

Also we would need the opposite for example 2 transaction tables ger merged into one staging table.

Any ideas on this would be very helpful

1. Re: Staging Tables and Envers

adamw Aug 3, 2011 9:00 AM (in response to tcanavan)

What do you mean by an entity being split?

And by merging transaction tables? Does it involve combining history from two different tables for same entities (rows with same ids)?

Adam
Actions
2. Re: Staging Tables and Envers

tcanavan Aug 3, 2011 9:38 AM (in response to adamw)

For example Say I have a PersonDetails source table I would like 2 staging/audit tables one for PersonAddress and one for PersonContacts.

or

I have PersonAddress and PersonContacts(source tables) and 1 audit/staging table which combines these 2 entities(Address and Contacts) into a PersonDetails audit/staging table.

The second use case is more important for us.

Hope this makes sense.
Actions
3. Re: Staging Tables and Envers

adamw Aug 9, 2011 2:34 AM (in response to tcanavan)

So you would like to have two tables in the "current" version, and one table in the "audit" one? I don't think that's possible with Envers unfortunately.
If I understand you correctly, that is.

Adam
Actions