Informatica

The course teaches the fundamental and advanced concepts of Informatica PowerCenter v9.x

  • 4.7
  • 105 Google reviews
Class Availability
Weekdays & Weekends
Course Duration
40-45 Hours
Training Methodology
25% Theory & 75% Practical

Class Availability

Weekdays & Weekends

Course Duration

40-45 Hours

Training Methodology

25% Theory & 75% Practical

4970

Profesionals Trained

350

Workshops Every Month

50

Countries And Counting

100

Corporate Served Successfully

Informatica PowerCenter v9.x (ETL)

The course teaches the fundamental and advanced concepts of Informatica PowerCenter v9.x, through online training including numerous hands-on lab exercises and real time scenarios. Students will gain a clear understanding of the product and acquire the solid foundation needed to make them efficient PowerCenter developers. Other top quality courses offered by IQ Stream Technologies Bangalore are Spring Java, Oracle Weblogic, JavaScript, IBM Datastage etc.

Objectives

  • Understanding the concepts of Data Warehousing
  • Ability to design and develop complex mappings
  • Configuring Workflows as in real time environment
  • Troubleshooting errors/failures
  • Gain hands-on experience with multiple exercises and various real time scenarios and a Demo Project
  • Build confidence to excel your career as an efficient Informatica Developer/Consultant

J2EE Syllabus

Advance JDBC Programming

  • Overview of Database Driver Architecture
  • Introduction to JDBC Standard Extension API (javax.sql)
  • Connection Pooling
  • JDBC Programming with ORACLE, MYSQL, etc.
  • Batch Processing
  • Working with Multiple Databases

Module #1 (Overview of Data Warehousing)

  • Introduction to Data warehouse (What/Why/How)
  • Star schema/Snowflake schema/Galaxy schema
  • Dimensions/Facts tables.
  • Slowly Changing Dimensions and its types.

Module #2 (Basic ETL)

  • Introduction to Informatica PowerCenter
  • (E)xtraction, (T)ransformation and (L)oading Process
  • PowerCenter Tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor)
  • Source and Target Object Definitions
  • Transformation Concepts (Types, Classifications, Basic uses)
  • ODBC & Relational Connections
  • Working with Flatfiles
  • Working with XML Files
  • Transformations:
    • Filter
    • Router
    • Sequence Generator
    • Rank
    • Sorter
    • Joiner
    • Union
    • Source Qualifier
    • Expression
    • Aggregator
    • Lookup (Connected/Unconnected)
    • Normalizer
    • Stored Procedure (Connected/Unconnected)
    • Update Strategy
    • Transaction Control
    • Java Transformation
    • SQL Transformation (Query/Script)
    • XML Parser
    • XML Generator

Module#3 (Advanced ETL)

  • Different Load Types
  • Slowly Changing Dimensions (Type – 1/2/3)
  • Indirect Method for Loading
  • Mapplets and Reusable Transformations
  • Parameters and Variables (Mapping and Workflow)
  • Different Types of Tasks:
    • Session
    • Email
    • Command
    • Assignment
    • Control
    • Timer
    • Decision
    • Event Wait
    • Event Raise
  • Working with Link
  • Worklets
  • Scheduler
  • Parallel and Serial Batching.
  • User Defined Functions
  • Incremental Aggregation
  • Constraint Based Loading
  • Target Load Plan
  • Performance Tuning
  • Pushdown Optimization
  • Wizards
  • Partitioning
  • Debugger

Akhilesh Kumar

    • 4.7
Positive: Communication, Professionalism, Quality, Value
It’s been pleasure taking the course of OIC at IQ Stream.
OIC training was good. Trainer Mr Bhaskar explained the topic nicely. He also provided the activities which helped hands on practice.

Ila Rana

    • 4.7
Positive: Communication, Professionalism, Quality, Value
It’s been pleasure taking the course of OIC at IQ Stream.
Great Institute… Sachin is an excellent trainer for Oracle HCM Fusion…. strongly recommend this institute for enhancing skills

gow thu

    • 4.7
Positive: Communication, Professionalism, Quality, Value

IQ Stream institute provides a very good technical class in practical way and they conduct soft skill classes as well. The soft skills classes helped me a lot to improve my communication and it’s very good for the people who wants to improve their communication.

    Request Course Demo


    Please prove you are human by selecting the Star.







    Training

    Related Courses

    Call Now ButtonCall Now

      Enquiry

      Please prove you are human by selecting the Plane.