Why Informatica sequences & Sybase/SQL server identity columns, should not be used?

Informatica provides the sequence object to create surrogate keys during load. These object is also sharable within various mappings hence can be used in parallel. But I will recommend never using it.  Here’s the Reason why…. 1. MIGRATION ISSUE:  The sequence is stored in the Informatica repository. That means it is disconnected from the target […]

Simulating Oracle Sequences in Sybase & SQL Server

Programmatic control is lost when identity columns are used in Sybase and SQL Server. I do not recommend using Identity columns to create surrogate keys during ETL process. There are many more reasons for that. Oracle has the sequence feature which is used extensively by Oracle programmers. I have no clue why other vendors are […]