Differences between SSIS and Informatica?
SSIS | Informatica |
---|---|
It is highly secure. | This is also highly secure. |
This is easy to use. | This is easy to use. This is a bit difficult and complex to use. |
The implementation of SSIS is comparatively easy. | The implementation of Informatica is comparatively difficult. |
It has no SaaS sources. | It has more than 80 SaaS sources. |
It has an incremental database replication based on a custom SELECT query. | It has an incremental database replication based on |
It does not support Auto Documentation | It supports Auto Documentation. |
It is open-source; i.e., it does not cost any money. | It is a premium software and costs money. |
BY Best Interview Question ON 04 Sep 2020