What is Informatica?.
Informatica offers different tools in ETL, Data integration, data masking, master data management etc. Informatica PowerCenter is a widely used extraction, transformation and loading (ETL) tool for building enterprise data warehouses. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse.
Maintained by | License Type | Popular Examples | Support | Updates | Developer Skills |
---|---|---|---|---|---|
Informatica developers | Proprietary | – | network.informatica.com | – | – |
Often Compared to | Testing | Accessibility | Maintained by | Repository |
---|---|---|---|---|
spark,talend | – | – | Informatica developers | informatica.com |
Pros:
- Excellent GUI interfaces for Administration, ETL Design, Job Scheduling, Session monitoring, Debugging, etc.
- Access to wide range of enterprise data sources
Cons:
- Lack of refresh option.
- It’s not possible to run a single session within a worklet.