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

Instructor
Name : Course Monkey
Reviews : 2 Reviews
Student : 1 Students
Courses : 114 Courses

Reviews

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