Informatica Corporation is the world’s number one independent provider of data integration software. Informatica worked on data extraction, transformation, and loading data from various sources like oracle, SQL Server and flat file. It is responsible for all activities related to the development, administration, and support of ETL process for large scale data warehouse using informatica power centre. Aspire Techsoft Pune, we are providing the informatica training on day time classes, weekend training batches.
evening batches and fast track batches. We are designing the course syllabus for informatica is to introduction of database, introduction to dataware house, informatica ETL tool, source, target, transformations, lookup, power centre components, score java is OOPS concepts, mapping, maplets, workflow manager, workflow monitor, performance tuning.
Importance of sql in informatica
Basics of rdbms
Operators in sql
Data types in sql (DML, TCL, and DDL)
Index in sql
OLAP and OLTP
Dataware house architecture
Star schema, snowflake schema