SCD using MERGE statement

Thanks to Warrent's Design Tip #107, it is very clear how to implement SCD Type 1 and Type 2 using the MERGE statement. However, if a dimension has both Type 1 and Type 2 attributes, we would need to run the MERGE for Type 1 separately, followed by MERGE for Type 2. Is my understanding correct? Is there anyway these 2 can be combined?

Thanks.

There's a SCD wizard on code plex that might be useful for generating your own coded SQL scripts.

No, they can't be combined. That is because the SCD2 changes affect just one existing row, the SCD1 changes affect all rows for that business key.

Also, if performance is an issue, you might want to look at alternatives. In my experience MERGE is slow.