There are 6 standard types of Slowly Changing Dimensions (SCD 0-5). Type 0 is no change allowed, Type 1 overwrites, Type 2 adds new rows with versioning, Type 3 adds columns for history, Type 4 uses a separate history table, Type 5 combines Type 2 and Type 4 (hybrid approach), and Type 6 is the full history tracking method that tracks all attribute changes separately. Each type addresses different business requirements for handling dimensional attribute changes.