MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Informatica Powercenter Certification Training

Course Summary

This Informatica training from Simplilearn trains you on Informatica PowerCenter. In this course you will gain a deeper insight into various aspects of the Informatica administrator console, master transformations, comprehend slowly changing dimension problems to sharpen your data warehousing skills.


  • +

    Course Syllabus


    Course preview

    Getting Started with Informatica

    Lesson 1 - Downloading Informatica Power Center 9.x 08:42

    1.1 The Course Overview 03:10

    1.2 Downloading the Tool 02:45

    1.3 Extracting the Tool from Its .zip File 02:47

    Lesson 2 - Installing and Configuring Power Center 05:22

    2.1 Installing the Server 04:04

    2.2 Installing the Client 01:18

    Lesson 3 - Getting Familiar with the Admin Console 08:58

    3.1 Configuring Domain and Node 04:25

    3.2 Configuring Repository and Integration Service 04:33

    Lesson 4 - Setting up Security, Permissions, and Client Configuration 04:47

    4.1 Configuring Users and Granting Permissions 02:01

    4.2 Configuring the Repository Manager 02:46

    Lesson 5 - Using the Designer Screen 18:04

    5.1 Using the Designer Client Interface 04:35

    5.2 Working with Sources as Files and Databases 08:49

    5.3 Working with Targets as Files and Databases 04:40

    Lesson 6 - Creating Mappings 06:48

    6.1 Creating a New Mapping 04:56

    6.2 Getting Acquainted with the Workflow Manager Screen 01:52

    Lesson 7 - Adding Transformation Using Input and Output Ports 06:33

    7.1 Using the Workflow Manager Interface 02:07

    7.2 Using the Workflow Manager 04:26

    Lesson 8 - Setting Up a Path and Connection 06:52

    8.1 Setting the Source And Target Paths 03:38

    8.2 Executing the Workflow 03:14

    Lesson 9 - Getting Accustomed to the Workflow Monitor Screen 06:28

    9.1 The Workflow Monitor 02:53

    9.2 The Workflow Log, Session Log, And Run Properties 03:35

    Lesson 10 - Working with the Repository Manager Screen 11:04

    10.1 Copy Paste and Drag Drop Features 06:42

    10.2 The Export Import Feature 04:22

    Implementing Informatica PowerCenter 9

    Lesson 1 - Using Transformations 27:02

    1.1 The Course Overview 01:53

    1.2 The Expression Transformation 08:57

    1.3 The Aggregator Transformation 05:57

    1.4 The Sorter Transformation 03:08

    1.5 The Filter Transformation 02:29

    1.6 The Router Transformation 04:38

    Lesson 2 - Using Advanced Transformations 24:22

    2.1 The Rank Transformation 03:07

    2.2 The Joiner Transformation 04:49

    2.3 The Union Transformation 02:59

    2.4 The Source Qualifier Transformation 06:30

    2.5 The Sequence Generator Transformation 06:57

    Lesson 3 - More Advanced Transformations 26:35

    3.1 Classification of Transformation 04:04

    3.2 The Lookup Transformation 09:57

    3.3 Types of Caches 06:05

    3.4 The Update Strategy Transformation 02:53

    3.5 The Stored Procedure Transformation 03:36

    Lesson 4 - Implementing SCD 21:37

    4.1 Understanding SCD Types 05:32

    4.2 Implementing SCD1 Mapping 08:10

    4.3 Implementing SCD2 Mapping 03:54

    4.4 Implementing SCD3 Mapping 04:01

    That was just a sneak-peak into the lesson.
    Enroll for this course and get full access.
    Enroll now


Course Fee:
USD 299

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top