Ssis Vs Informatica

Informatica

ssis

1. Informatica has More aggregate functions

1. Ssis has few aggregate functions

       2. It uses sequence transformation to create                  surrogate key.

     2) It uses a script transform component to create           a surrogate key.

3. Informatica uses the debugger present in the Informatica Designer

3) SSIS uses the debugger present in the visual studio