General Information

 

Trainer Profile

Our Trainer is specialized in offering exclusive Hands on Training in Informatica Power Center and IDQ. Our trainer is an Informatica certified consultant having 15 years of realtime work experience and more than 6 years of teaching experience.

This training is 100% online mode.

 

Step Module Description
1 IPC 100 Informatica Power      Center 9.5 Course

Course Deliverables

Classroom Training: ​Apart from the core conceptual knowledge that we deliver. All examples and practicals will be demonstrated practically on servers (Nothing will be just Theary!).

 

Lab: ​Students can create and destroy virtual machines on demand, to practice things learned in the class.

 

MODULE TOPICS (IPC 100)

 

Heading   Topic
Data Warehouse Concepts 1.1 Need of Data Warehouse
  1.2 Characteristics of OLTP and OLAP
  1.3 Significance of ETL
 
Architecture of Data Warehouse 2.1 – Definition of Data Warehouse
  2.2 – Dimension and Fact Tables
  2.3 – Star Schema
  2.4 – Snow Flake Schema
  2.5 – Importance of Staging Area
  2.6 – Initial Load
  2.7 – Incremental Load/Delta Load
  2.8 – Surrogate Keys
 
Slowly Changing Dimensions (SCD) 3.1 – SCD Type 1
  3.2 – SCD Type 2
  3.3 – SCD Type 3
 
Types of Dimensions and Fact Tables 4.1 – Time Dimension
  4.2 – Types of Facts — Additive, Semi Additive, Non Additive
  4.3 – Fact less Fact Table
 
ETL in Bigdata World 5.1 –  Introduction to Big Data
  5.2 –  Where ETL fits in Big Data World
  5.3 –  Introduction to Hadoop
 
Understanding the Role of a Developer 6.1 –      Understanding the project flow from requirement Gathering to Production
  6.2 –      Documentation maintained at each level in the flow
  6.3 –      Data Mapping Document
  6.4 –      Production Support Responsibility
 
Overview of Different Client Tools 7.1 –      PowerCenter Designer
  7.1.1 –      Source Analyzer
  7.1.2 –      Target Designer
  7.1.3 –      Transformation Designer
  7.1.4 –      Mapplet Designer
  7.1.5 –      Mapping Designer
  7.2 –      WorkFlow Manager
  7.2.1 –      Task Developer
  7.2.2 –      Worklet Developer
  7.2.3 –      Workflow Developer
  7.3 –      Workflow Monitor
 
Mapping Designer and Transformations 8.1 – Create a Simple Mapping
  8.2 – Overview of Transformations
  8.3 – Types of Transformations — Active and Passive
  8.4 – Expression Transformation
  8.5 – Source Qualifier Transformation
  8.6 – Filter Transformation
  8.7 – Router Transformation
  8.8 – Aggregator Transformation
  8.9 – Sorter Transformation
  8.10 – Rank Transformation
  8.11 – Reusable Transformation
  8.12 – Normalizer Transformation
  8.13 – Union Transformation
  8.14 – Stored Procedure Transformation
  8.15 – Sequence Generator Transformation
  8.16 – Joiner Transformation
  8.17 – Update Strategy Transformation
  8.18 – Lookup Transformation
  8.19 – Static, Dynamic and persistent Lookup Cache
  8.20 – SCD Type 1 mapping Implementation
  8.21 – Connected Vs Un-Connected Transformations
  8.22 – Multiple Pipelines in a Single Mapping
 
Tools for Unit Testing 9.1 – Debugger
  9.2 – Verbose Data
  9.3 – Test Load
 
Different Types of Sources 10.1 – Flat Files
  10.2 – Delimited Files
  10.3 – Fixed Width Files
  10.4 – Handling Multiple Files as Source (indirect File method)
  10.5 – Data Base Tables
  10.6 – XML Files
  10.7 – Cobol Files
 
Workflow Tasks 11.1 – Command Task
  11.2 – Email Task
  11.3 – Task Link Properties
  11.4 – Event Raise Task
  11.5 – Event Wait Task
  11.6 – Sequential and Parallel Loading
  11.7 – Scheduler
 
Reusable Features in Informatica 12.1 – Reusable Transformations
  12.2 – Mapplets
  12.3 – Reusable Tasks
  12.4 – Worklets
 
Advance Features in Informatica 13.1  Mapping parameter and Variables
  13.2 – Session parameter
  13.3 – Incremental Loading
  13.4 – Parameter Files
  13.5 – Export and Import on Objects
  13.6 – Incremental Aggregation
  13.7 – Creating dependency on sessions
  13.8 – Partitioning
  13.9 – Deployment Group
  13.10 – Pmcmd
 
Types of Repositorries 14.1 – Global Repositories
  14.2 – Shortcut of objects
  14.3 – Local Repositories
  14.4 – Version Controlled Repository
 
ETL Testing 15.1 –  STLC
  15.2 – Bug Life Cycle
  15.3 – Structure Validation, Count Validation, Data Validation
  15.4 – Integration Testing, Volume Testing, Performance Testing
  15.5 – Severity and Priority
 
Miscellaneous 16.1 –      Introduction to Shell Script
  16.2 –      Introduction to Data Modeling
  16.3 –      Scheduling Tools
  16.4 –      Agile Vs Water Fall Model
 

Duration: 30 Hours

Course Fee: $500

For more details, visit our site www.solwinsys.com

Email at trainings@solwinsys.com

Phone:  908-666-7411