Informatica Powercenter Online Training by Janani
Description
Informatica is a company that provides products for ETL data integration , data masking, data quality , data replication, virtualization of data, master data management, etc. The most widely used data integration method for linking and fetching data from various data sources is Informatica ETL.
Informatica is a widely accepted method for the development of enterprise data warehouses for extraction, transformation , and loading (ETL). Informatica PowerCenter components help extract data from its source, translate it into company specifications and load it into the target repository.
Training Outcome
-
Course Complete Certificate
Requirements
- Bachelor Degree in Computer Science
Lessons
- 41 Lessons
- 41:00:00 Hours
- Data warehousing Concepts01:00:00
- ETL Fundamentals01:00:00
- Informatica Installation01:00:00
- Architecture in Informatica01:00:00
- Creating a Domain/Folder01:00:00
- Components in Informatica Client01:00:00
- (a) What is ETL? (b) Need of ETL (c) What are ETL tools? (d) Role of ETL in DWH01:00:00
- Designer Overview01:00:00
- Creating a Source using Source Analyzer - Working with Database Sources01:00:00
- Creating a Source using Source Analyzer - Working with Flat files01:00:00
- Creating a Target using Target Definition01:00:00
- Creating a Mapplet Introduction to Transformations- Active/Passive01:00:00
- Transformations – II Expression / Source qualifier01:00:00
- Transformations – III Filter / Router01:00:00
- Transformations – IV Union / Joiner01:00:00
- Transformations – V Aggregator / Rank01:00:00
- Transformations-VI Normalizer / Sequence generator01:00:00
- Transformations-VII XML Source qualifier / Sorter01:00:00
- Transformations-VIII01:00:00
- Working with Ports / Working with Expressions01:00:00
- Workflow Manager Overview and Workflow Manager Options01:00:00
- Workflows and Worklets01:00:00
- Sessions01:00:00
- Tasks01:00:00
- Sources01:00:00
- Targets01:00:00
- Validation ‐Validating Tasks -Scheduling and Running Workflows01:00:00
- Workflow Monitor Overview -Overview01:00:00
- Session and Workflow Logs01:00:00
- Creating a simple mapping and Execution01:00:00
- Source Extraction / Data Transformation Logic / Data Loading01:00:00
- Features and Techniques01:00:00
- Joins and Link Conditions01:00:00
- (a) Source Qualifier and joining two relational sources. (b) Executing sessions with Link Conditions.01:00:00
- Using the Debugger01:00:00
- IInd level Transformations – Part 1 Sequence Generators01:00:00
- IInd level Transformations – Part 201:00:00
- II nd level Transformations – Part 301:00:00
- Mapping Design Workshop01:00:00
- Repository Manager01:00:00
- Performance Tuning01:00:00
About instructor

Reviews
0
Based on 0 Reviews
1 Stars
2 Stars
3 Stars
4 Stars
5 Stars