Skip to content

Implementing Informatica PowerCenter 9 [Video]


Packt Publishing

Summary

Price
£105.06 inc VAT
Or £35.02/mo. for 3 months...
Study method
Online
Duration
1 hour · Self-paced
Qualification
No formal qualification

Overview

Video Description

This video course begins by teaching you all there is to know about transformations, one of the most important aspects in Informatica. These transformations are arranged on the basis of their importance and usage. You will learn how to use transformations such as Aggregator and Filter, after which you will move on to more advanced transformations such as Joiner, Union, and Rank. The second half of this course revolves around how to classify transformations, based on whether they're active/passive, or connected/unconnected. Finally, you will learn to implement the Slowly Changing Dimension problem and sharpen your data warehousing skills!

Style and Approach

This video addresses installing Informatica Power Center. It will take viewers through a step-by-step approach to download and install the Informatica Power Center Server and Client. We will also take a look at various aspects of the Admin Console, such as the Repository, Domain, Node, Integration Service, and so on.

Description

What You Will Learn

  • Use various transformations such as Expression and FilterLearn
  • Use advanced transformations such as Rank and JoinerClassify active, passive, connected, and unconnected transformations
  • Implement SCD1, SCD2, and SCD3 mappings

Authors - Rahul Malewar

Rahul Malewar is a data warehouse consultant, providing Business Intelligence and Data Analytical solutions to customers. He has worked on various Data Warehousing tools for 10 years, majorly on Informatica Power Center--various versions of Informatica Power Center, from version 8.1 to the latest 10.1.0. He has experience of working on multiple real-time projects in a couple of MNCs, utilizing the skills acquired from which, he has written this book. He has been running his own training center named Learn Well Technocraft for seven years now, wherein training on more than 25 Data warehousing, Cloud Computing, and Data Analytical technologies is provided over classroom, corporate, and online means. He has also written a blog on data warehousing concepts. As of today, he has provided training to more than 1,700 candidates, ranging from freshers to professionals with 20 years of experience in Informatica.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.