How do I change a non historized attribute

Pavel

hey, guys! AM looks very good and Im trying to implement a DWH using it.

A question - what if I have a non historized attribute (non business key) and I need to change it?

Like there was a mistake in customers name and it was fixed the next day.

I have a SSIS sequence and a table for this attribute and in order to add new row (with the same surrogate ID) I have to delete the old one (because of unique index). But it would be very slow (row-by-row).

I could create a temp table and put all changes (incl deletes) in it, then fast delete changed rows from attribute table (using join) and then move all rows from temp table to attribute table.

Two problems:

1. I have to duplicate all tables in DB. Another approach would be programmatically create temp tables in tempdb, but its more complicated.

2. Its not very elegant solution imho :) And it feels like there is one much better.

How do I handle this situation?

Roenbaeck

This is a limitation of deletes not being batchable through SSIS, so you get the row-by-row behaviour. The workaround is to make the attribute historized, insert the rows, and then run a delete-statement if you really need to get rid of the history.