Informatica Tutorial: Beginner to Expert Level

Informatica Tutorial: Beginner to Expert Level, available at $84.99, has an average rating of 4.48, with 291 lectures, 33 quizzes, based on 7811 reviews, and has 35859 subscribers.

You will learn about Understand Data Warehouse Concepts and ETL Concepts Describe Informatica PowerCenter architecture & its different components Use PowerCenter 10x/9.x components to build Mappings, Tasks, Workflows Describe the basic and advanced features functionalities of PowerCenter 10.0/9.6 transformations Understand Workflow Task and job handling Describe Mapping Parameter and Variables Perform debugging, troubleshooting, error handling and recovery Learn different types of cache available and how to calculate cache requirement and implement session cache Execute performance tuning and Optimization Identify and explain the functionalities of the Repository Manager tool Identify how to handle services in the Administration Console Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation Gain insight on ETL best practices using Informatica Understand all the basic interview questions for all the transformations and real time scenarios This course is ideal for individuals who are Software Developers or Analytics Professionals or BI/ETL/DW Professionals or Mainframe Developers and Architects or Individual Contributors in the field of Enterprise Business Intelligence It is particularly useful for Software Developers or Analytics Professionals or BI/ETL/DW Professionals or Mainframe Developers and Architects or Individual Contributors in the field of Enterprise Business Intelligence.

Enroll now: Informatica Tutorial: Beginner to Expert Level

Summary

Title: Informatica Tutorial: Beginner to Expert Level

Price: $84.99

Average Rating: 4.48

Number of Lectures: 291

Number of Quizzes: 33

Number of Published Lectures: 288

Number of Published Quizzes: 33

Number of Curriculum Items: 324

Number of Published Curriculum Objects: 321

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Understand Data Warehouse Concepts and ETL Concepts
Describe Informatica PowerCenter architecture & its different components
Use PowerCenter 10x/9.x components to build Mappings, Tasks, Workflows
Describe the basic and advanced features functionalities of PowerCenter 10.0/9.6 transformations
Understand Workflow Task and job handling
Describe Mapping Parameter and Variables
Perform debugging, troubleshooting, error handling and recovery
Learn different types of cache available and how to calculate cache requirement and implement session cache
Execute performance tuning and Optimization
Identify and explain the functionalities of the Repository Manager tool
Identify how to handle services in the Administration Console
Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
Gain insight on ETL best practices using Informatica
Understand all the basic interview questions for all the transformations and real time scenarios

Who Should Attend

Software Developers
Analytics Professionals
BI/ETL/DW Professionals
Mainframe Developers and Architects
Individual Contributors in the field of Enterprise Business Intelligence

Target Audiences

Software Developers
Analytics Professionals
BI/ETL/DW Professionals
Mainframe Developers and Architects
Individual Contributors in the field of Enterprise Business Intelligence

Informatica Power Center Data Integration tool is the top in the Gartner’s magic quadrantfor the past ten years with high GO LIVE rate compared to any other existing ETL tools in the market.

Informatica Power Center tool supports all the steps of Extraction, Transformation and Load process/life cycle. There are lot of other (third party) products which are offered and created around the Power Center’s ability to connect to different technologies ranging from Legacy systems, Mainframes to CRM, SAP, TIBCO, HP VERTICA to BIG DATA.

Informatica Power Center Developer course, will introduce you to work with the Power Center version 10.x/9.6x to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations and enterprise data warehouse setup.

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 architecture of Informatica 10x/9x is created based on the SOA (Service Oriented Architecture) which takes care of the data fetch, execution of the transformation and load the data into the target systems in the desired formats like Relational, Flat File, XML, WSDL, PDF, Word (Structured, Semi-Structured, Un-Structured).

Informatica Power Center 10x/9x has the ability to communicate via ODBC sources/plugins/extensions with all major data sources like Mainframe, Big Data, traditional RDBMS (Oracle, SQL Server, Teradata, Netezza, Informix, DB2 etc), NoSQL(Mongo DB, Cassandra etc) Flat Files, XML, TIBCO, WSDL (Via web services) SAP, Salesforce etc) and move/transform data between them based on the need.

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.

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 (clearly shown and explained), usually asked interview questions, 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.�

Course Curriculum

Chapter 1: Some basic information about the course before you start

Lecture 1: Welcome and Thank you!!

Chapter 2: Data Warehouse Concepts : Back to Basics

Lecture 1: Why do we need a Data Warehouse?

Lecture 2: What is a Data Warehouse?

Lecture 3: What is Business Intelligence?

Lecture 4: What is Business Intelligence? – Extended

Lecture 5: The Complete Master Data Warehouse Concepts Course

Chapter 3: Data Warehouse Architectures

Lecture 1: Enterprise Architecture or Centralized Architecture

Lecture 2: Federated Architecture

Lecture 3: Multi Tired Data Warehouse Architecture

Lecture 4: Components of a Data Warehouse Architecture

Lecture 5: Purpose of Staging Area in a Data Warehouse Architecture

Lecture 6: Purpose of Staging Area in a Data Warehouse Architecture – part 2

Chapter 4: ODS VS OLTP Vs OLAP

Lecture 1: What is ODS?

Lecture 2: Features and Benefits of ODS

Lecture 3: Staging Vs ODS

Lecture 4: OLAP Overview

Lecture 5: OLTP Vs OLAP -Part 1

Lecture 6: OLTP Vs OLAP – Part 2

Lecture 7: Differences between ODS,DWH, OLTP, OLAP, DSS and Data Mart

Chapter 5: Data Mart

Lecture 1: What is a Data Mart?

Lecture 2: Fundamental Difference between DWH and DM

Chapter 6: Dimensional Modeling

Lecture 1: What is Dimensional Modeling?

Lecture 2: What is a Dimension?

Lecture 3: What is a Fact?

Lecture 4: What is a Surrogate key?

Lecture 5: Star Schema

Lecture 6: Snow flake Schema

Lecture 7: SnowFlake Vs Star Schema

Lecture 8: Conformed Dimension

Lecture 9: Junk Dimension

Lecture 10: Degenerate Dimension

Lecture 11: Slowly Changing Dimensions – Intro and Example

Lecture 12: Slowly Changing Dimensions – Type 1, 2 and 3

Lecture 13: Slowly Changing Dimensions – Summary

Chapter 7: Data Warehouse Indexes

Lecture 1: What is an Index?

Lecture 2: Bit-Map Index

Lecture 3: BTree Index

Lecture 4: BTree Vs BitMap

Chapter 8: ETL Vs ELT

Lecture 1: What is Data Integration?

Lecture 2: ETL – Explained

Lecture 3: ELT – Explained

Lecture 4: ETL Vs ELT

Lecture 5: Commonly used terms in an ETL project – Part 1

Lecture 6: Commonly used terms in an ETL project – Part 2

Lecture 7: MDM – Golden Source explained

Chapter 9: Different Tools/Technologies used in DWH/BI/ETL

Lecture 1: Different Types of Enterprise Databases

Lecture 2: Different ETL tools available in the Market

Lecture 3: Which ETL tool should you learn?

Chapter 10: Roles and Responsibilities of ETL Developer

Lecture 1: Roles and Responsibilities of an ETL Developer – Part 1

Lecture 2: Roles and Responsibilities of an ETL Developer – Part 2

Lecture 3: Roles and Responsibilities of an ETL Developer – Part 3

Chapter 11: Informatica Power Center Architecture

Lecture 1: Informatica Domain Architecture

Lecture 2: Informatica Nodes/Core Services/Gateway Nodes

Lecture 3: Types of Nodes, Common Issues and Troubleshooting

Chapter 12: Informatica Version 9.6 : Installation and Configuration

Lecture 1: Pre Installation Steps & System Pre-Requisites

Lecture 2: Quick Tip: Product Availability Matrix – PAM

Lecture 3: Where to get the software and download it? Officially and Legally

Lecture 4: Too many files!! Which one do I need to downlaod?

Lecture 5: Oracle 11g Installation and SQL Developer Configuration

Lecture 6: File Extraction for Installation from Oracle eDelivery

Lecture 7: Informatica PowerCenter 9.6 – Server Installation

Lecture 8: Informatica Power Center 9.6 – Client Installation

Chapter 13: Informatica Version 9.6: Administration Console

Lecture 1: Administration Console Introduction

Lecture 2: List of Services

Lecture 3: Setting up Repository Service

Lecture 4: Repository Service Properties – Part 2

Lecture 5: Setting up Integration Service

Lecture 6: Integration Service properties

Lecture 7: Repository Configuration and Folder Creation

Lecture 8: Start and Stopping the services

Chapter 14: Informatica Power Center Versions

Lecture 1: Informatica 10 – New Features

Chapter 15: Informatica Version 10 Installation and Configuration

Lecture 1: Informatica 10 – Server/Client Installation – Part 1

Lecture 2: Informatica 10 – Server/Client Installation – Part 2

Chapter 16: Informatica 10 – Administrator Console

Instructors

Sid Inf
Data/ETL Architect

Rating Distribution

1 stars: 111 votes
2 stars: 171 votes
3 stars: 1079 votes
4 stars: 3122 votes
5 stars: 3328 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu