We want to use the Database functionality in SQL Server, Identity, to preserve primary key integrety.
I can not find any information regarding the use of Identity columns in SQL Server in combination with Data Integrator.
Anyone that knows anything about this, and how this can be achived in BODI with the BODI transformation such as Table Compare, Key_Generation, Map operation and so on.
We are using Data Services 3.1 on a MS SQL Server 2005 platform, where target is a MS SQL Server 2008.