Home Courses Instructor Labs

Informatica 36 Hours Tutorial

(20 Ratings) 1134 Students Enrolled
Created By Akash Singh Last Updated Fri, 03-Jul-2020 English
  • Course Duration
    37 Hours
  • Mode of Training
    Self-Paced
  • Lessons
    38 Lessons
  • Placement Assistance
    Guaranteed
Free
12k+ satisfied learners Read Reviews
What Will I Learn?
  • Learn how to understand Data Warehouse Concepts and ETL Concepts
  • Learn all the Informatica PowerCenter architecture and its different components
  • Workflow task and Job handlings
  • Mapping parameter and variables
  • Identify the functionalities of the Repository Manager tool
  • Learn how to execute performance tuning and Optimization

Requirements
  • Basic Knowledge on SQL
  • Basic Knowledge on UNIX commands
+ View More
Description

Informatica is one of the best tool for Data Integration. In this course, you will be learning Extraction, Transformation and Load process/life cycles.

Informatica Powercenter is an easy to use GUI based tool in which we use simple drag and drop feature for different objects like

  • Sources and targets
  • Transformations
  • Mapplets
  • Mappings
  • Sessions
  • Worklets
  • Workflows

The objects are integrated into the packages called workflow. This course covers you the following concepts such as

  • Data Warehousing concepts
  • Dimensional Modelling
  • ETL designs
  • Filter Transformations
  • Router Transformations
  • Sorter Transformations
  • Aggregator Transformations
  • Joiner Transformations
  • Source Qualifier Transformations
  • Lookup Transformations
  • Update Strategy Transformations
  • Transaction Control Transformations

and much more!


Curriculum For This Course
38 Lessons 37 Hours
  • Data warehousing Basics 01:09:30 Preview
  • Dimentional Modelling Facts Types of Dimensions 01:28:44 Preview
  • ETL Design OLTP OLAP Staging Schema 01:10:36
  • Designer-workflow monitor - repository manager 00:47:36
  • Transformations - Expressions - Mapplets 01:15:32
  • Expressions - Encryption - Cross Linking 00:58:59
  • Filter Transformation 00:43:22
  • Router Transformation 00:56:50
  • Sorter Transformation 00:57:05
  • Practicals - Database Connections 01:12:01
  • Aggregator Transformation 01:05:55
  • Joiner Transformation 01:14:11
  • Source Qualifier Transformation 01:18:58
  • Source Qualifier - pre and post sql 00:48:01
  • Lookup transformation 01:00:48
  • Lookup Transformation Static and Dynamic 01:02:44
  • Normalizer - Flat File 00:51:45
  • Sequence Generator 00:53:35
  • Update Strategy Transformation 00:53:24
  • Transaction Control Transformation 00:55:04
  • XML - Source to Target Incremental Load 00:56:54
  • Stored Procedure - Connected - Unconnected 00:52:25
  • Stored Procedure - Pre and post Load 00:33:52
  • Batch Processing - Interview Discussion 00:50:14
  • Batch Processing - Timer Task 01:09:14
  • WorkFlow and Mapplets 00:50:05
  • Update Operations - Mapping and Session level 00:13:23
  • Update Operation without Update Strategy 00:46:07
  • Update Strategy - Update else Insert 00:55:46
  • Incremental Loading 01:04:28
  • Slowly Changing Dimension - with Lookup 01:08:07
  • Slowley Changing Dimension without Lookup 00:12:50
  • Handling huge Data - Lookups and Indexes 01:18:32
  • Slowly Changing Dimension 2 01:09:52
  • Dynamic Lookup 01:03:12
  • Data Driven Aggregation 01:10:07
  • Incremental Aggregation 00:20:55
  • Incremental Aggregation - Aggregator Cache 01:12:54

Informatica 36 Hours Tutorial