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.
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?