Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Development Tools Informatica PowerCenter

Informatica Tutorial: Beginner to Expert Level

Become an expert in world's top Data Integration tool.
Bestseller
Rating: 4.3 out of 54.3 (5,652 ratings)
21,989 students
Created by Sid Inf
Last updated 4/2020
English
English [Auto], Portuguese [Auto]
30-Day Money-Back Guarantee

What you'll 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

Course content

73 sections • 288 lectures • 35h 10m total length

  • Preview10:00

  • Why do we need a Data Warehouse?
    05:26
  • What is a Data Warehouse?
    05:48
  • What is Business Intelligence?
    05:37
  • What is Business Intelligence? - Extended
    03:34
  • The Complete Master Data Warehouse Concepts Course
    01:58
  • Test your understanding on Data Warehouse & Business Intelligence
    4 questions

  • Enterprise Architecture or Centralized Architecture
    04:46
  • Federated Architecture
    03:05
  • Multi Tired Data Warehouse Architecture
    03:13
  • Components of a Data Warehouse Architecture
    03:57
  • Purpose of Staging Area in a Data Warehouse Architecture
    04:43
  • Purpose of Staging Area in a Data Warehouse Architecture - part 2
    03:35
  • Test your understanding on Data Warehouse Architectures
    3 questions

  • What is ODS?
    02:20
  • Features and Benefits of ODS
    02:18
  • Staging Vs ODS
    01:56
  • OLAP Overview
    05:54
  • OLTP Vs OLAP -Part 1
    04:33
  • OLTP Vs OLAP - Part 2
    06:01
  • Differences between ODS,DWH, OLTP, OLAP, DSS and Data Mart
    04:01
  • Test your understanding ODS, OLAP, OLTP, Data Warehouse
    4 questions

  • What is a Data Mart?
    01:47
  • Fundamental Difference between DWH and DM
    00:36
  • Test your understanding on Data Marts
    3 questions

  • What is Dimensional Modeling?
    04:39
  • What is a Dimension?
    02:48
  • What is a Fact?
    02:05
  • What is a Surrogate key?
    04:01
  • Star Schema
    05:23
  • Snow flake Schema
    03:25
  • SnowFlake Vs Star Schema
    05:27
  • Conformed Dimension
    06:38
  • Junk Dimension
    03:06
  • Degenerate Dimension
    03:35
  • Slowly Changing Dimensions - Intro and Example
    05:30
  • Slowly Changing Dimensions - Type 1, 2 and 3
    12:30
  • Slowly Changing Dimensions - Summary
    03:33
  • Test your understanding on Dimensional Modeling
    5 questions

  • What is an Index?
    02:12
  • Bit-Map Index
    04:17
  • BTree Index
    01:56
  • BTree Vs BitMap
    03:22
  • Test your understanding on Data Warehouse Indexes
    4 questions

  • What is Data Integration?
    06:49
  • ETL - Explained
    06:41
  • ELT - Explained
    05:57
  • ETL Vs ELT
    02:23
  • Commonly used terms in an ETL project - Part 1
    07:52
  • Commonly used terms in an ETL project - Part 2
    06:34
  • MDM - Golden Source explained
    09:21
  • Test your understanding on ETL Vs ELT
    3 questions

  • Different Types of Enterprise Databases
    04:46
  • Different ETL tools available in the Market
    06:48
  • Which ETL tool should you learn?
    03:12
  • Test your understanding on different types of ETL Tools
    1 question

  • Roles and Responsibilities of an ETL Developer - Part 1
    07:27
  • Roles and Responsibilities of an ETL Developer - Part 2
    06:11
  • Roles and Responsibilities of an ETL Developer - Part 3
    07:31
  • Test your understanding on Roles and Responsibilities of an ETL developer
    1 question

Requirements

  • Knowledge of basic SQL
  • Basic Unix Commands

Description

Informatica Power Center Data Integration tool is the top in the Gartner’s magic quadrant for 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. 

Who this course is for:

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

Featured review

Mindaugas Lukosius
Mindaugas Lukosius
38 courses
6 reviews
Rating: 5.0 out of 5a year ago
In compare to other Informatica Power Center 10 courses I found this one most extensive and one of the rare ones where each topic is followed at least with one practical example. They are not real world problems, but close enough to understand usage.

Instructor

Sid Inf
Data/ETL Architect
Sid Inf
  • 4.2 Instructor Rating
  • 12,978 Reviews
  • 52,446 Students
  • 17 Courses

Business Intelligence Consultant and Trainer with 14+ years of extensive work experience on various client engagements. Delivered many large data warehousing projects and trained numerous professionals on business intelligence technologies. Extensively worked on all facets of data warehousing including requirement gathering, gap analysis, database design, data integration, data modeling, enterprise reporting, data analytics, data quality, data visualization, OLAP.

Has worked on broad range of business verticals and hold exceptional expertise on  various ETL tools like Informatica Powercenter, SSIS, ODI and IDQ, Data Virtualization, DVO, MDM.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.