Informatica Course

leading provider of enterprise data integration software

Informatica Online Training

CSRCIND Provides Informatica Online Training Informatica's product is a portfolio focused on Data Integration: ETL, Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Master Data Management, Ultra Messaging; currently at version 9.6 These components form a toolset for establishing and maintaining enterprise-wide data warehouses. It has a customer base of over 5,000 companies.

What you will learn

Informatica is a widely used ETL tool for extracting the source data and loading it into the target after applying the required transformation,Informatica enables organizations to gain a competitive advantage in today’s global information economy by empowering companies with timely,relevant and trustworthy data for their top business imperatives.

  • INTRODUCTION TO DATAWAREHOUSING
  • PowerCenter Components and User Interface
  • Source Qualifier
  • Expression, Filter, File Lists and Workflow Scheduler

Informatica Online Training Course Content

 

  • Data Ware Housing Concepts:
  • Introduction to Data Warehousing
  • Introduction to OLTP, ETL and OLAP Systems
  • Life Cycle
  • Data Modeling
  • Normalization Forms
  • Dimensional Modeling
  • Star Schema
  • Snowflake Schema
  • Types of Fact and Dimension Tables
  • Oracle Concepts:
  • Introduction to Oracle
  • Data Types
  • Constraints
  • SELECT statement usage
  • Joins
  • Sub Queries
  • Performance Tuning Tips & Tricks
  • Introduction to ETL
  • Enterprises of ETL Architecture
  • Introduction to Informatica
  • Installation & Configuration of Informatica
  • Repository Creation & Management

 

  • Designer
  • Source Analyzer
  • Warehouse Designer
  • Transformation Developer
  • Mapplet Designer
  • Mapping Designer
  • Different Kinds of Transformations
  • Simple Mapping
  • Mapping Involving Multiple Sources
  • Multiple Targets
  • Complex logic Mapping
  • Slowly Changing Dimension
  • Example of each Transformation available
  • Mapping Parameters & Variables
  • Performance Tuning Tips & Tricks
  • Debugging
  • Workflow Manager:
  • Task Developer
  • Worklet Designer
  • Workflow Designer
  • Different Kinds of Tasks and Usage
  • Control Tasks
  • Workflow Control and Monitoring
  • Performance Tuning
  • Session and Workflow Parameters
  • Project Related:
  • Real time Project Scenarios
  • Complete Real Time Project Exposure
  • Professional Resume Preparation
  • Mock Interviews
  • FAQ
  • Complete Job Assistance
Back to top