Informatica Power Center 10.x
Administration and Development
WE provide you job oriented training on Informatica by Most experienced faculty
Demo
What is Informatica? Is it coding technology or GUI technology? Is it complex/simple?
Where do we use Informatica?
What is Data Warehouse?
How does Informatica part of Data Warehouse?
What are the other technologies need to know to learn/work on Informatica?
How do we teach Informatica?
Transformations
Active and Passive Transformations
Active Transformation:-
• Source qualifier: - Covers implementation & Uses in data extraction from different source systems based on SQL
• Aggregator: - Covers how to implement SQL Group concept & its differences between SQL to Informatica.
• Filter: - Covers how to implement SQL WHERE clause to filter data in Informatica with comparisons
• Sorter: - Covers how to implement SQL ORDER BY clause to sort data in Informatica with comparisons
• Joiner: - Covers how to implement SQL JOINS to merge data in Informatica with comparisons
• Router: - Covers how to implement SQL clause to catch true and false data in Informatica with comparisons
• Update strategy: - Covers how to implement SQL DML to do INSERT/UPDATE/DELETE/REJECT data on Target databases through Informatica with comparisons
• Ranking: - Covers how to implement SQL RANK with TOP/BOTTOM ranks in Informatica with comparisons
• Union: - Covers how to implement SQL UNION/UNION ALL functionality in Informatica with comparisons
• XML Source Qualifier transformation: - Covers how to extract data from XML source and Informatica Meta data imports/exports.
• SQL Transformation: - Covers how to implement SQL's statement including DDL/DML/TCL/Data retrieval in Informatica with comparisons
• Transaction control: - Covers how to implement SQL TCL on data process in Informatica with comparisons
• Lookup: - Covers how to implement SQL Joins with outer join to compare data between different data sources in Informatica with comparisons
Passive Transformations:-
• Expression: - Covers how to implement SQL ROW functions (String, numeric, date & conversion) in Informatica with comparisons
• Stored Procedure:- Covers how to execute/call PL/SQL procedure from data base to informatica in Informatica with comparisons
• Lookup: - Same as above with why LOOK UP is active and passive
• Sequencer Generator: - Covers how to work SQL SEQUENCE in Informatica with comparisons
• SQL Transformation: - Same as above with why LOOK UP is active and passive
-------------------------------------------------------------------------------------------------------------------------------
01 Introduction to Informatica
Introduction to Course
Where Informatica Power Center IPC is used
Data Warehouse projects and Why use Informatica
Roles and Responsibilities of Informatica Developer
Roles and Responsibilities of Informatica Administrator
What is Informatica Power Center IPC
02 ETL and Various ETL Tools
What is ETL
Various ETL Tools in Market
03 Data Transformation
What is Data Transformation
Types of Data Transformation
Example of Data Transformation
04 Informatica Power Center Components
Informatica Power Center Components
Power Center Designer
Workflow Manager
Workflow Monitor
Repository Manager
Admin Console
05 Informatica Power Center Architecture
Informatica Client-Server Architecture
Repository Services
Integration Service
What is domain
06 Installation and Configuration of Informatica Power Center
Installation Steps Overview
Oracle 11g Setup and Configuration
Power Center Server Setup and Configuration
Power Center Client Setup and Configuration
07 Understanding Source and Target
Types of Sources
Type of targets
Source Analyzer in Informatica
Target Designer in Informatica
08 Create Mappings, Session and Workflows
Create a Mapping To load Source Table to Target Table
Create a Mapping to load Source Table to Flat file Target
Create a Mapping to load Flat File Source to Target Table
Creating a Session and Workflow
09 Session Properties
Session properties Overview
Fail Parent if Task Fails
Write Backward Compatibility Session Log File
Bulk vs Normal Load
Save Session Log for These Runs
How to use Pre or Post SQL
How to Send Email
Stop on Error
Commit Interval
10 Link Conditions
Link Conditions Concept
Link Condition Example
11 Multiple Target and Target Load Plan
Loading Source data to multiple target - File and Relational
Target Load Plan Concept
Target Load Plan Example
Issues with having 2 pipeline loads in 1 mapping
12 Transformations
13 Expression Transformation
Expression Transformation Concepts
Expression Transformation Example
IIF Expression Example
ERROR Function in Expression
ABORT Function in Expression
Difference between ERROR and ABORT
14 Filter Transformation
Filter Transformation Concept
Filter Transformation Example
Filter Transformation to Monitor Performance Concept
Filter Transformation to Monitor Performance Example
15 Router Transformation
Router Transformation Concept
Router Transformation Example
16 Joiner Transformation
Join Concept
Joiner Transformation Inner or Equal Join Example
Joiner Transformation Right Outer Join Example
Joiner Transformation Left Outer Join Example
Joiner Transformation Full Outer Join Example
17 Lookup Transformation
Lookup Transformation Concept
Simple Lookup Table example
Lookup Transformation Multiple Match Values Concept
Lookup Transformation First Value Example
Lookup Transformation Last Value Example
Lookup Transformation Any Value Example
Lookup Transformation Report Error Example
Lookup Transformation Use All Values Example
Unconnected and Connected Lookup Concept
Unconnected Lookup Example
18 How to use Informatica Help
How to use Informatica Help for more functions
19 Union Transformation
Union Transformation Concept
Union Transformation Example
20 Sorter Transformation
Sorter Transformation Concept
Sorter Transformation Example with 1 key
Sorter Transformation Example with more than 1 key
Sorter Transformation to get unique records after Union
21 Aggregator Transformation
Aggregator Transformation concepts
Aggregator Transformation Example
Use of Aggregator to remove duplicates Concept
Use of Aggregator to remove duplicates Example
22 Rank Transformation
Rank Transformation Concept
Rank Transformation Example - Using Top Bottom Ranking
23 Sequence Generator Transformation
Sequence Generator Transformation Concept
Sequence Generator Transformation Example
24 Stored Procedure Transformation
Stored Procedure Transformation Concept
Stored Procedure Transformation Example
25 Slowly Changing Dimension
Slowly Changing Dimension Concept
SCD Type1 Concept
SCD Type1 Example
SCD Type2 Concept
SCD Type2 Example
SCD Type3 Concept
SCD Type3 Example
26 Workflow
What is Workflow
Creating Workflow
Monitoring workflows and debugging errors
27 Tasks
What is Task
Creating Decision task
Creating Control Task
Creating Event wait task
Creating Timer task
What is Reusable tasks - session, email and command
Creating Reusable tasks
28 Reusability - Worklet Maplet
What is Worklet
Creating Worklet
What is Maplet
Creating Maplet
Reusable Transformations Concept
Reusable Transformations Example
29 Sessions
What is Session
Creating Session
30 Scheduling Workflow
What is Scheduler
Using Scheduler to run example
31 Import - Export of Objects
Export Example
Import Example
Folder Copy
32 Indirect File Load
Indirect File Load Concept Examples
33 Integrity Constraint Load Ordering
Integrity Constraint concept
primary key and foreign key example
Constraint based loading example
34 Session Parameters and Variables
Session Parameters Concept
Session Parameters Example
35 Target Load Order Plan
Target Load plan Concept
Where or When we need Target Load Plan
Target Load plan Example
Project Explanation, implementation & Testing:-
• Functional explanation of Project this is the important part of learning.
• Dimensional modeling usage in Project
• How to load and Test Dimension Tables
• How to load and Test Fact Tables
• How to load and Test Aggregate Tables
• How to test Project from developer point
• How to load final DataMart tables at a time
How to do Code Migration and Post production validation:-
What is Task and Types of Tasks: - .
• Reusable
• Session
• Command
• Email
• Non Reusable
• Session
• Command
• Email
• Assignment
• Decision
• Event-Raise
• Event-Wait
• Timer
Variables & Parameters at objects:-
• Mapping • Session • Workflow
Informatica Cache Process:
• What is cache in informatica?
• Types of caches and how those works
• Which Transformations will create cache?
• Types of look up caches
• What is Static Look up cache?
• What is Persistence Look up cache?
• Dynamic look up cache with SCD1 mapping
Performance Tuning:-
• Source Bottlenecks
• Target Bottlenecks
• Mapping Bottlenecks
• System bottlenecks
• Session bottlenecks
Data Warehouse Testing (Called as ETL Testing) :
• Types of testing
• Responsibility of developer in testing
• Unit testing
• Regression testing
• Integration testing
• Performance testing
• Acceptance testing
Note:-
Data Warehouse concepts with real examples: -
Covers all DW FAQ's including real examples
2. SQL questions with practical explanation: -
Covers SQL related FAQ's which are asked in Interview's
3. Informatica FAQs including interview scenarios: -
Covers Informatica related FAQs which are asked in Interviews including complex scenarios and its answers.
4. Unix FAQs with practical explanation: -
Covers UNIX related FAQs which are asked in Interviews
5. Final one and ultimate one is Job process and go through steps by real experts
