May 6, 2008 at 4:33 am
what is main diff between informatica and SSIS?
May 6, 2008 at 5:09 am
Informatica is a much more robust Enterprise wide ETL tool.
SSIS has similar functionality but does not perform as well.
In informatica you map the data flows on the field level, so it is much easier to split data off to separate transformations. This can trap new developers as they all have to form back in the logical order.
SSIS only maps single data flows between mappings so you can not split them out easily.
I find SSIS to be to caught up with data-types and data sources and changes in these can easily break a mapping.
Informatica has a lot better logging ability and the client-server architecture provides far better performance and scalibility.
Informatica is far more expensive and SSIS comes with SQL Server, given the choice i would use Inofrmatica.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply