Informatica Powercenter Certification Training
Simplilearn Americas LLC
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 Description
Who delivers the training?
All our trainers are certified and are highly qualified, with multiple years of experience in working in ETL, data-warehousing and Informatica.Is this live training, or will I watch pre-recorded videos?
All the classes are live. They are interactive sessions that enable you to ask questions and participate in discussions during the class time. We do, however, provide recordings of each session you attend for your future reference.Can I cancel my enrollment? Do I get a refund?
Yes, you can cancel your enrollment if necessary. We will refund the course price after deducting an administration fee. To learn more, you can view our Refund Policy.Are there any group discounts for classroom training programs?
Yes, we have group discount options for our training programs. Contact us using the form on the right of any page on the Simplilearn website, or select the Live Chat link. Our customer service representatives will give you more details.What payment options are available?
Payments can be made using any of the following options. You will be emailed a receipt after the payment is made.Visa Credit or Debit card
MasterCard
American Express
Diner’s Club
PayPal
I’d like to learn more about this training program. Who should I contact?
Contact us using the form on the right of any page on the Simplilearn website, or select the Live Chat link. Our customer service representatives will give you more details.What is Global Teaching Assistance?
Our teaching assistants are here to help you get certified in your first attempt.
They are a dedicated team of subject matter experts to help you at every step and enrich your learning experience from class onboarding to project mentoring and job assistance.
They engage with the students proactively to ensure the course path is followed.
Teaching assistance is available during business hours.
What is covered under the 24/7 Support promise?
We offer 24/7 support through email, chat, and calls.
We also have a dedicated team that provides on-demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.
-
+
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