Learn Informatica Master Data Management (Mdm)-2022

You will learn how Informatica performs various activities such as data profiling, data cleansing, transforming.

What you'll learn
You will learn how Informatica performs various activities such as data profiling, data cleansing, transforming, and scheduling the workflows from source to tar
Why We Need Informatica? To perform some operations on the data at the backend in a data system, To modify, cleaning up the data based on some set of rules.
It provides a broad set of features such as integration of the data from multiple unstructured, semi-structured or structured systems, operations at row level .
It also supports the features of metadata, so it keeps preserved the information of the process and data operations.
Requirements
Before learning Informatica, you must have the basic knowledge of Data warehouse and ETL based tools.
Description
The goal of my Course is:- First of all starting to understand how Informatica works.- I will make it quite easy to understand and follow. So afterwards you can start from Scratch your Informatica Tool or maybe to learn something new that you did not know about it.- This Course is great, so expect the from basics to some advanced tips and strategies from Informatica, so you can start putting your hands on it without making any kind of investment at this point.About the Course:The course covers all topics starting from Data warehouse concepts, Roles and Responsibilities of an ETL developer, Installation & Configuration of Informatica Power Center 10x/9.X, in detailed explanation of transformations with practical examples, performance tuning tips for each transformation, quizzes for each section and assignments for your hands on and in-depth explanation of the Repository Service, Integration Service and other basic Administration Activities.The Informatica Master Data Management (MDM) course is designed to get deep drive into the Master Data Management Concepts . It includes all the components of MDM which will help anyone to excel in his work. This course is for all levels who would like to enhance their knowledge about Informatica MDM.The course focuses on various concepts used in the Informatica MDM including Architecture / PowerCenter / Cloud/ ETL / Informatica Transformations / Performance Tuning.Informatica Power Center is an easy to use GUI based tool. It has a simple visual interface which is easy to understand and use. All the components are designed to be used by a simple drag and drop feature for different objects like source, targets, transformations, mapplets, mappings, sessions, worklets and workflows which contribute to the design process flow of the data extraction, transformation and load.Once the objects are integrated into a package called as workflow, it can be scheduled to run as and when required with rich features to accommodate all the possibilities of a business requirement.The tool’s ability to fetch/transform and load huge volumes of data in a very effective way, with less resource consumption is better than hand coded programs written for specific data movement using PL/SQL procedures, Java, Perl and other languages.

Overview

Section 1: Introduction about Me and Course

Lecture 1 Some Basic info about the Informatica Master Data Management Course-2021

Section 2: Introduction & Overview of Informatica Master Data Management

Lecture 2 What is Informatica MDM?

Lecture 3 Why we need Informatica?

Lecture 4 Data Extraction,Data Transformation, Data Loading

Lecture 5 Informatica Key Metrics

Section 3: Architecture of Infromatica (MDM)

Lecture 6 What is Informatica Archtecture?

Lecture 7 Node & PowerCenter Repository in Informatica

Lecture 8 PowerCenter Client and Server Connectivity

Section 4: Informatica PowerCenter ETL Tool

Lecture 9 What is Informatica PowerCenter ETL tool?

Lecture 10 Services of Informatica PowerCenter

Lecture 11 Informatica PowerCenter Products

Section 5: Versions of Informatica PowerCenter

Lecture 12 Informatica PowerCenter Tool Versions

Lecture 13 PowerCenter Express ETL

Section 6: Downloading & Installing Infromatica PowerCenter Tool

Lecture 14 How to download Informatica PowerCenter Tool?

Lecture 15 How to Install Informatica PowerCenter Tool & Working (Part 1)?

Lecture 16 How to Install Informatica PowerCenter Tool & Working (Part 2)?

Section 7: Mapping in Informatica (MDM)

Lecture 17 What is Mapping in Informatica?

Lecture 18 Why we need Mapping Informatica?

Lecture 19 Components of Informatica Mapping

Lecture 20 What is Stage Mapping?

Lecture 21 Mapping Parameters and Variables

Section 8: Informatica Cloud Master Data Management (MDM)

Lecture 22 What is Informatica Cloud?

Lecture 23 Informatica Cloud Components

Lecture 24 Use Cases of Informatica Cloud

Section 9: Informatica Master Data Management

Lecture 25 What is MDM?

Lecture 26 The Need of Master Data Management

Lecture 27 Some Challenges of Master Data Management

Lecture 28 Future of Master Data Management

Lecture 29 Trends and best practices of Master Data Management

Section 10: Informatica Extract, Transform and Load (ETL)

Lecture 30 What is Informatica ETL?

Lecture 31 Implementation of ETL Tool

Lecture 32 Features of ETL Tool

Section 11: Informatica Transformations

Lecture 33 What is Informatica Transformations?

Lecture 34 some Classification of Transformation

Lecture 35 What is Filter Transformation?

Lecture 36 Practical Activity-Filter Transformation

Section 12: Source Qualifier Transformation in Informatica

Lecture 37 What is Source Qualifier Transformation?

Lecture 38 Source Qualifier Transformation Properties

Lecture 39 Practical Activity- Source Qualifier Transformation

Lecture 40 Practical Activity- Source Qualifier Transformation Part2

Lecture 41 Practical Activity- Source Qualifier Transformation Part3

Section 13: Aggregator Transformation in Informatica

Lecture 42 What is Aggregator Transformation?

Lecture 43 Configuring the Aggregator Transformation

Lecture 44 Properties of Aggregator Transformation

Lecture 45 Practical Activity- Creating an Aggregator Transformation

Section 14: Router Transformation in Informatica

Lecture 46 What is Router Transformation?

Lecture 47 Practical- How to create Router Transformation?

Section 15: Joiner Transformation in Informatica

Lecture 48 What is Joiner Transformation?

Lecture 49 Two Sources of Joiner Transformation

Lecture 50 Types of Joins

Lecture 51 Configuring Joiner Transformation

Lecture 52 Practical Activity- How to join two tables using joiner transformation

Section 16: Rank Transformation

Lecture 53 What is Rank Transformation?

Lecture 54 Types of ports in Rank Transformation

Lecture 55 What is Rank Index?

Lecture 56 Practical Activity- How to use Rank Transformation?

Section 17: Sequence Generator Transformation

Lecture 57 What is The Sequence Generator transformation?

Lecture 58 Two output ports of The Sequence Generator transformation

Lecture 59 Practical Activity- How will generate sequence numbers and store in the target?

Section 18: Lookup Transformation in Informatica

Lecture 60 What is Lookup Transformation?

Lecture 61 Following tasks using a Lookup transformation

Lecture 62 Configure the Lookup Transformation

Section 19: Normalizer Transformation

Lecture 63 What is Normalizer Transformation in Informatica?

Lecture 64 Types of Normalizer Transformation

Lecture 65 Practical Activity- Normalizer Transformation

Section 20: Performance Tuning in Informatica

Lecture 66 Performance Tuning in Informatica

Lecture 67 The goal of performance tuning is to optimize session performance

Section 21: Some Additional Document files for Informatica PowerCenter Tool

Lecture 68 Informatica BDM

This course is for anyone (beginners and professionals) who wants to start his carrier in Informatica Master Data Management (MDM) or to get deep dive on the Informatica Master Data Management (MDM) Concepts,Individual Contributors in the field of Enterprise Business Intelligence,Informatica MDM Developer , Senior Developer , Architect or as Tester,BI/ETL/DW Professionals,Software Developers & Analytics Professionals