I am testing the SCD with some sample data and am seeing duplicate rowsgetting insertedinto my table. When configuring the wizard I am prompted to select a key type (Business or Not a key column). I assumed that the SCD wizard would NOT insert a row that already has a business key in the dimension table but that doesn't seem to be the case??? Is that by design?

Are you sure they are duplicates and not "expired" rows?Regardless, ensure that your incoming data is cleansed of trailing spaces, and know that CaSE matters when matching.

I have the same problem and the lines are exactly the same, the next two lines are the result of my etl process: 40321 321102 32.000000 1.000000 1.000000 0.000000 2.000000 DWS_CLINICO HCD GH NULL NULL NULL NULL HCD 39182 321102 32.000000 1.000000 1.000000 0.000000 2.000000 DWS_CLINICO HCD GH NULL NULL NULL NULL HCD the first column is the primary key of the dimension the second column is the business identifier (key), both (321102) are exactly the same

Is that definately a key column, you might need to check your key column definition.http://uk.linkedin.com/in/ramjaddu