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