Surrogate keys can be generated without a Sequence Generator transformation by using Expression transformations with logic like variables and counters to create sequential unique values, or by using database sequences, stored procedures, or other methods.