top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Can anybody compare SSIS 2014/SSIS2012 with Informatica Power center ?

+1 vote
502 views

SQL SERVER 2014 SSIS has been released,we have already got lot of facilities in SQL SERVER 2012 SSIS.Can anybody compare SSIS 2014/SSIS2012 with Informatica Power center ? What are the additional fetures are there in the Informatica new version than SSIS 2012/2014? Or are there functions in SSIS 2014/20122 ,which are not available in Informatica.

posted Mar 4, 2014 by Shweta Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

This would take some time to name all the differences. These products are quite similar at the first glance, but I will try to name few features that would distinguish them.
•PowerCenter (PC) can run on grid distributing work across nodes
•PC is able to connect to: •Messaging platforms (e.g. Tibco)
•Salesforce
•social media sources
•Hadoop
•SAP

•PC can run on Unix
•allows Real Time integration
•allow data lineage from underlying database up to reporting layer
•allows assigning memory per component
•allows to easily see number of rows passing each transformation

answer Mar 4, 2014 by Rohini Agarwal
...