Informatica Tutorial: Beginner to Expert Level

5.0 /5

(2 Ratings)

Offered byUDEMY

Informatica Tutorial: Beginner to Expert Level
at
UDEMY
Overview

Become an expert in world's top Data Integration tool

Duration	35 hours
Total fee	₹3,499
Mode of learning	Online
Credential	Certificate

Informatica Tutorial: Beginner to Expert Level
at
UDEMY
Highlights

Earn a Certificate of completion from Udemy
Learn from 17 downloadable resources
Comes with 30 days money back guarantee and full lifetime access

Informatica Tutorial: Beginner to Expert Level
at
UDEMY
Course details

Skills you will learn

Data mining OLAP SAP Informatica Data Warehousing Big Data

Who should do this course?

For Software Developers
For Analytics Professionals
For BI/ETL/DW Professionals
For Mainframe Developers and Architects

What are the course deliverables?

Data warehouse concepts
Roles and Responsibilities of an ETL developer
Installation & Configuration of Informatica Power Center 10x/9.X
Explanation of transformations
Workflow Task and job handling

More about this course

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 Tutorial: Beginner to Expert Level
at
UDEMY
Curriculum

Data Warehouse Concepts : Back to basics

Why do we need a Data Warehouse?

What is a Data Warehouse?

What is Business Intelligence?

What is Business Intelligence? - Extended

The Complete Master Data Warehouse Concepts Course

Data Warehouse Architectures

Enterprise Architecture or Centralized Architecture

Federated Architecture

Multi Tired Data Warehouse Architecture

Components of a Data Warehouse Architecture

Purpose of Staging Area in a Data Warehouse Architecture

Purpose of Staging Area in a Data Warehouse Architecture - part 2

ODS vs OLTP vs OLAP

What is ODS?

Features and Benefits of ODS

Staging Vs ODS

OLAP Overview

OLTP Vs OLAP -Part 1

OLTP Vs OLAP - Part 2

Differences between ODS,DWH, OLTP, OLAP, DSS and Data Mart

Data Mart

What is a Data Mart?

Fundamental Difference between DWH and DM

Dimensional Modeling

What is Dimensional Modeling?

What is a Dimension?

What is a Fact?

What is a Surrogate key?

Star Schema

Snow flake Schema

SnowFlake Vs Star Schema

Conformed Dimension

Data Warehouse indexes

What is an Index?

Bit-Map Index

BTree Index

BTree Vs BitMap

Informatica Tutorial: Beginner to Expert Level
at
UDEMY
Faculty details

Sid Inf

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.