Informatica

About the Course

Informatica is a 30 hours course curriculum that covers fundamental concepts of the data warehouse, facts, dimensions, installation, development of mapping, sessions, work flows for moving the data across heterogeneous systems.

 

Course Objective

After completion of Informatica course, you will be able to

  • Apply for the jobs in Data Warehouse and Informatica
  • Understand the concepts of data Warehouse
  • Create Informatica ETL programs for data movement
  • Use complex Informatica transformation
  • Create workflow and schedule
  • Troubleshoot and resolve technical issues

 

Course pre-requisites

Basic knowledge of SQL is good but not mandatory

 

Course Content

Data warehouse Concepts
  • What is Data warehouse?
  • Components of Data warehouse
  • Decision support systems
  • OLTP Systems
  • OLTP vs DATAWAREHOUSE
  • ODS(Operational Data Store)
  • Difference between ODS and Data Mart
  • Difference between Data warehouse and Data Mart
  • Difference between Data warehouse and ODS, OLTP
  • Data warehousing for OLTP systems
  • Data cleansing
  • Independent Data warehouse
  • Dependent Data warehouse
  • Meta data and Data Mining
  • OLAP, ROLAP, MOLAP
Database design and Data Modeling
  • ER Model for transactional processing
  • Introduction to Data Modeling
  • Entities and Attributes
  • What is the use of data modeling in Data warehousing?
  • Schema
  • Star Schema
  • Snowflake Schema
  • Snowflake Schema (hybrid schema or galaxy schema)
  • Fact Table
  • Dimension Tables
  • Multi dimension Tables
ERWIN (Data Modeling Tool)
  • Introduction to Erwin
  • Usage of Erwin
  • Physical and Logical Model
  • Creation of Table
  • Forward Engineering
  • Reverse Engineering
  • Complete compare
  • Domains
  • Subject areas
  • Relationships
  • Demoralization
Types of Transformations:
  • Source qualifier
  • Aggregator
  • Filter
  • Expression
  • Stored Procedure
  • Lookup
  • Sorter
  • Joiner
  • Router
  • Update strategy
  • Normalizer
  • Ranking
  • Sequencer Generator
  • Transaction control
  • Union
  • Custom
  • SQL Transformation
  • Mapplets
  • Slowly Changing Dimensions (SCD)
  • Reusable transformations
  • Working with mapping using Debugger
  • Variable and Parameters
Workflow Manager
  • Components of workflow manager
  • Types of tasks
  • Session
  • E-mail
  • Command
  • Creating workflow
  • Scheduling the workflow
  • Creating connections
  • Assigning connections to the sessions
  • Assigning server to workflow
  • Workflow monitor
  • Session logs
  • Workflow logs
INFORMATICA 9.0/8.6
  • Introduction of Informatica power center
  • ETL Architecture
  • Data source
  • ETL Architecture
  • Data source
  • Data Targets
  • Repository
  • Meta data
  • Server components
  • Client components
Informatica Installation
  • System Requirement
  • Creating Domain
  • Creating Node
  • Creating repository service and the Integration service
Informatica Repository Manager
  • Creating the workspace (folder)
  • Creating the users
  • Changing the user passwords
  • Creating users groups
  • Giving privileges to the users, user groups and folder
Informatica Designer
  • Connecting to the designer
  • Components of the designer
  • Creating DSN (data source name)
  • Source, Database
  • Accessing the source, definitions to the designer
  • Creating the target Tables using warehouse designer
  • Generating target Table to database
  • Mapping Designer
  • Mapping between the source and target Tables
  • Transformations between source and target Tables
Performance Tuning
  • Source Bottlenecks
  • Target Bottlenecks
  • Mapping Bottlenecks
  • System bottlenecks
  • Session bottlenecks
Data Warehouse Testing
  • Types of testing
  • Responsibility of developer in testing
  • Unit testing
  • Regression testing
  • Integration testing
  • Performance testing
  • Acceptance testing
Advanced Concepts
  • Dynamic lookup cache
  • Pushdown optimization
  • Partitions in Informatica
  • Constraint based loading
  • Incremental Aggregation
  • Automated Error Handling
  • Recovery mechanisms
  • Backup and restoration
  • Dynamic parameter file creation
  • Java Transformation
  • Http Transformation