Home Courses Instructor Labs

Informatica PowerCenter Training

(689 Ratings) 3712 Students Enrolled
Created By Prerana Krishna Last Updated Fri, 03-Jan-2020 English
  • Course Duration
    20 Hours
  • Mode of Training
    Self-Paced
  • Lessons
    153 Lessons
  • Placement Assistance
    Guaranteed
$ 149.99 $ 14.99 90% off 100% Money Back Guarantee
12k+ satisfied learners Read Reviews
What Will I Learn?
  • Understand Data Warehouse Concepts and ETL Concepts
  • Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
  • Understand Workflow Task and job handling
  • Describe Informatica PowerCenter architecture & its different components
  • Describe the basic and advanced features functionalities of PowerCenter 9.6 transformations
  • Gain insight on ETL best practices using Informatica
  • Crack the Informatica Interviews
  • Understand all the basic interview questions for all the transformations and real time scenarios
  • Understand Data Warehouse Concepts and ETL Concepts
  • Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
  • Understand Workflow Task and job handling
  • Describe Informatica PowerCenter architecture & its different components
  • Describe the basic and advanced features functionalities of PowerCenter 9.6 transformations
  • Gain insight on ETL best practices using Informatica
  • Crack the Informatica Interviews

Requirements
  • Basic SQL knowledge is required
  • Laptop or Desktop with Internet connection
+ View More
Description

Informatica is a widely used ETL tool which is used to extract the raw data and load it to target data after making some transformations. ETL means "Extract Transform Load" which refers to the processes performed when transforming raw data to a data warehouse or relational databases.

Informatica is a user-friendly tool which has simple visual interface forms. At the end of this training, you will be skilled to  Informatica Development, Architecture and various transformations. And also you will be highly equipped with advanced skills needed for Informatica development.

The main components of Informatica PowerCenter are its Client tools, Server, Repository Server and Repository. The PowerCenter Server and repository server makes up the ETL layer, which completes the ETL processing.

As this tool is easy to use tool, you simply drag and drop the objects like source, mappings, worklets, etc.

Curriculum For This Course
153 Lessons 20 Hours
  • Introduction to Informatica 00:06:45 Preview
  • Informatica Dataware Housing 00:09:35 Preview
  • Data Mart in Informatica 00:07:02
  • ETL Diagram 00:08:51
  • Example of ETL 00:06:13
  • More on Informatica 00:06:45
  • PowerCenter Designer in Informatica 00:03:45
  • PowerCenter Workflow 00:03:48
  • PowerCenter Monitor 00:02:31
  • PowerCenter Repository 00:03:21
  • Overview of Informatica 00:01:53
  • Download Java in Informatica 00:03:44
  • Installation of Java File in Informatica 00:02:45
  • Downloading Orcale For Informatica Server 00:04:28
  • Downloading Sql Developer For Informatica Server 00:04:51
  • Installation of SQL Developer 00:06:51
  • Creating a Connection Between Sql Developer and Java 00:06:02
  • Download and Install Informatica 00:05:18
  • Installation of Informatica 00:03:16
  • Installation of Informatica Continue 00:06:43
  • Pre Installation of Informatica Server 00:08:21
  • Server Installation of Informatica Server 00:04:57
  • Server Installation of Informatica Server Continues 00:06:00
  • Informatica Server Client Installation 00:07:41
  • Loading Data to Target 00:09:37
  • Customer Table Demo 00:07:51
  • Developing Mapping 00:09:00
  • Transform Apply Logic 00:10:55
  • Creating WorkFlow 00:10:27
  • Loading Data by Transformation 00:08:12
  • Creating Customer Details 00:07:42
  • Creating Mapping 00:07:01
  • Working with Function Concat 00:08:43
  • Applying Transformation Logic 00:07:31
  • Checking Valid Mapping 00:05:20
  • Concatinating Names 00:08:18
  • Overview in Expression Transformation 00:02:04
  • Concept of Router Transformation 00:04:45
  • Using Router Transformation 00:09:33
  • Applying Expression Transformation 00:06:45
  • Router Transformation Demo 00:05:02
  • Grouping in Router Transformation 00:12:03
  • Creating Work Flows 00:09:48
  • Analyzing in SQL Developer 00:08:59
  • Concept of Filter Transformation 00:09:01
  • Comparing Router and Filter Transformation 00:04:45
  • Loading Data in Target Table 00:07:14
  • Validating Filter Properties 00:04:34
  • Filter Transformation Demo 00:05:01
  • Tutuorials on Router Transformation 00:03:08
  • Comparison between Router and Filter 00:08:27
  • Source and Source Qualifier 00:07:15
  • Different Target Tables 00:11:21
  • Loading Data for Target Tables 00:08:53
  • Advantages of Router Transformation 00:08:25
  • Advantages of Router Transformation Continues 00:08:22
  • Understanding Aggregator Transformation 00:07:19
  • Scenario for Aggregator Transformation 00:10:01
  • Functions for Aggregator Transformation 00:08:51
  • Editing in Aggregator Transformation 00:09:22
  • Working in Target Table 00:08:50
  • Data from the Source File 00:08:33
  • Truncating the Table 00:04:11
  • Understanding the Joiner Transformation 00:05:56
  • Different types of Joins 00:07:19
  • Functions of Master Outerjoin 00:07:36
  • Generating and Executing SQL 00:09:13
  • Mapping the Codes for Targets 00:07:52
  • Understanding Details Outer Join 00:09:23
  • Workflow from Designer Window 00:08:36
  • Learning Full Outerjoin 00:10:12
  • Truncate Target Table Option 00:05:48
  • Defining the Normal Join 00:09:41
  • Checking the Connection Details 00:06:43
  • Performing Normal Join on Example 00:09:23
  • Creating a New Target Table 00:06:39
  • Executing the Workflow for Normal Join 00:03:32
  • Concept of Rank Transformation 00:11:22
  • Practical Example on Rank Transformation 00:08:24
  • Defining Rank Properties 00:09:57
  • Designing the Transformation Attributes 00:05:27
  • Understanding the Sequence Transformation 00:09:46
  • Creating Table and Loading Data 00:10:56
  • Understanding Lookup Transformation 00:09:37
  • Example on Lookup Transformation 00:09:23
  • Cashed or Uncashed Lookup 00:08:37
  • Learning Unconnected Lookup 00:10:21
  • Demo for Connected and Unconnected Lookup 00:06:27
  • Data Type of Different Lookups 00:11:15
  • Creating the Workflow 00:08:34
  • Initializing in Workflow 00:07:47
  • Example on Unconnected Lookup 00:08:43
  • Unconnected Lookup Mapping 00:10:29
  • Unconnected Lookup Mapping Continues 00:09:41
  • Different Lookups in Mapping 00:09:11
  • Introduction to Informatica Powercentre Advanced 00:08:09
  • Union Transformation box 00:07:54
  • Analyzing the Designer Pattern 00:08:32
  • Creating a Workflow 00:07:52
  • Check in the Objects 00:07:02
  • Checkout and Editing 00:07:02
  • Comparing Objects and Export 00:08:37
  • Introduction to Normalization Transformation 00:11:58
  • CID and GK Value 00:08:04
  • Student Score 00:09:10
  • Workflow Normalizer 00:09:04
  • Sequel Developer 00:07:44
  • Mapping Designer 00:06:15
  • What is Normalisation Transformation 00:07:15
  • Sales Demo 00:09:06
  • Normalizer Import Export 00:08:00
  • Introduction to Update Strategy Tranformation 00:11:21
  • Options 00:06:11
  • What is the Scenario 00:10:32
  • Workflow 00:07:40
  • Update the Record 00:12:09
  • Source file Directory 00:08:32
  • Stored Procedure Transformation 00:10:18
  • Connected Stored Procedure Transformation 00:08:01
  • Source Table 00:06:22
  • Target Table 00:06:54
  • Dollar Target 00:09:16
  • Unconnected Stored Procedure Transformation 00:09:37
  • Unconnected Transformation Method 00:08:00
  • Introduction to Slowly Changing Dimensions 00:10:02
  • SCD Type 00:10:08
  • Select Department Table 00:09:27
  • Department Table Continue 00:07:14
  • Updated Record 00:09:20
  • Department Current Data 00:07:14
  • Conclusion SCD 00:04:08
  • Slowly Changing Dimension Type 2 00:07:00
  • Slowly Changing Dimension Type 2 Continue 00:07:00
  • Generate Execute SQL 00:09:05
  • Updated Location 00:11:25
  • Max of Version 00:03:16
  • Use Router Transformation 00:08:27
  • Used to Filter Transformation 00:07:19
  • SRC Table 00:06:27
  • Intoduction to Flag 00:08:07
  • Flagging Demo 00:08:32
  • Sequence Generator Transformation 00:10:22
  • Passing the Serial Number 00:08:40
  • SRC Flag Values 00:06:04
  • Active Records 00:05:42
  • Slowly Changing Dimension Type 3 00:09:12
  • Expression Transformation 00:09:08
  • New records and Updated Records 00:06:39
  • New records and Updated Records Continue 00:05:47
  • Introduction to Mapplet 00:07:20
  • Mapplet Input and Mapplet Output 00:07:26
  • Employee Commission Data 00:04:39
  • Parameter Variable 00:05:26

Informatica PowerCenter Training