INFORMATICA ONLINE TRAINING

Training 24x7 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.

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
  • 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
  • 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
  • Project Related:
    • Real time Project Scenarios
    • Complete Real Time Project Exposure
    • Professional Resume Preparation
    • Mock Interviews
    • FAQ
    • Complete Job Assistance

Please Register with us