Subject: Informatica

Location: Lansing, Michigan

Duration: 40 Hours

Fee: $1500.00

Learn from an expert instructor. Our expert instructors are themselves have years of experience in the real world as well as in teaching. A large majority of our instructors are Full-time consultants and provide solutions to a wide variety of companies.

Topics to be covered

TRAINING IS BASED ON CERTIFICATION CURRICULUM AND PROJECT SCENARIOS.

Introduction to Data Warehousing

• What is Data Warehousing
• Who needs Data Warehouse
• Operational Systems
• Decision Support Systems

OLTP Vs OLAP

• ODS (Operational Data Store)
• Data warehousing Life Cycle
• OLAP, ROLAP, MOLAP & HOLAP
• Decision Support Systems

Data Modeling

• Introduction to Data Modeling
• Entities and Attributes
• Use of Data Modeling in Data Warehousing
• Dimensions tables
• Hierarchies
• Fact tables
• Granularity for the Data Warehousing
• Star Schema
• Snowflake Schema
• Galaxy Schema
• Types of Facts
• Types of Dimensions

Part-I

Introduction to Informatica
ETL Architecture

1.Introduction to Informatica Client Tools

• RSAC
  • Creating a Repository
  • Connecting to the Rep Server
• Repository Manager
  • Creating Folders, Users & Groups
  • Privileges to the Users, User Groups & Folders
• Designer
  • Connecting to Designer
  • Components of Designer
  • Creating DSN
  • Importing Source & Exporting Target
  • Types of Ports
  • Developing simple Pass through mapping
  • Tips to use Designer efficiently
• Workflow Manager
  • Components of Workflow Manager
  • Creating & Configuring Informatica Server
  • Developing Session & Workflow
  • Setting Session Properties
  • Assigning Infa Server to Workflow
• Workflow Monitor
  • Connecting to Infa Server
  • Monitoring the Workflow & Session
  • Session log & Workflow Log

2.Designer Transformations

• Naming Conventions
• Connected Vs Unconnected
• Active Vs Passive
• Source Qualifier
  • As a filter
  • Join Condition
  • Optimizing SQL override
• Expression
• Filter
• Sequence Generator
• Rank
• Router
• Aggregator
• Joiner
• Stored Procedure (Connected & Unconnected)
• Lookup (Connected Vs Unconnected)
• Union
• XML
• Normalizer
• Custom

3. Implementing Type-I, Type-II, Type-III mappings

• Using Mapping Wizards
• Three different approaches

4. Workflow Manager

• Tasks
  • Session
  • Decision
  • Command
  • Email
  • Event Raise & Event wait
  • Link Conditions
• Developing Worklet
• Using Worklet in the Workflow
• Session task Properties
• Workflow Properties
• Scheduling workflow

5. Testing the Mapping

• Manually
• Using Performance Statistics
• Using Tracing Level
• Using Debugger

6. Working with Files

• Where & How to place Files
• Flat file as a Source and Target
• Dealing with Flat Files

7. Advanced Features

• Mapplet Implementation
• Mapping Parameters and Variables
• Reusable Transformations
• Global Definitions & Creating Shortcuts
• Session Parameters
• Bulk Loading
• Incremental Aggregation
• Target Load Plan
• Constraint Based Loading
• Deployment Process
• Sending Notification Messages

Call us at (517) 803-4385 or Email: info@eastwestlc.com (Information including Training date and time)