PHONE +91 9620196773, +91 8884684156
EMAIL info@iqstreamtech.com
Call for Free Demo +91 9620196773, +91 8884684156, 080-42073645


Informatica PowerCenter v9.x (ETL)

About:

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

Other Related Courses:

Hadoop Developer Training
Datastage Training
Javascript Training
Spring Training
Weblogic Training

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#4 (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 Links
* Worklets
* Scheduler
* Parallel and Serial Batching.
* User Defined Functions
* Incremental Aggregation
* Constraint Based Loading
* Target Load Plan
* Performance Tuning
* Pushdown Optimization
* Wizards
* Partitioning
* Debugger