Informatica 8.6 online training by real time employees @ Optimus

[david_optimus]

Informatica 8.6 Course Content


Introduction to Data Warehousing

 What is Data Warehousing?
 Who needs Data Warehousing?
 Why Data Warehouse is required?
 Types of Systems
(i) OLTP (ii) DSS    (iii)OLAP
 Maintenance of Data Warehouse
 Data Warehousing Life Cycle


Introduction
• Overview
• Basic Definitions
• Informatica Products
• Intormatica Architecture
• Tools and their roles
• Folders-Sub folders
• Power Center / Power Mart


Informatica Designer – Introduction
• Introduction to Designer
• Logon to Designer
• Designer interfaces
• Designer Tools
• Defining Sources
(i) Database as a source
(ii) Flat File Sources
• Defining Targets
• Importing from database
• Creating a new target
• Creating target database objects


Informatica Designer
• Mapping Introduction
• Source Qualifier
• Ports
• Mapping – Table to Table
• Mapping Flat File to Table
• Connected/Unconnected Transformations
• Active and Passive Transformation
• Source Qualifier Transformation
• SQL Override-Source Qualifier Transformation
• Mapping Source Qualifier and Filter
• Source Qualifier to Join Data
• Filter Transformation
• Expression Transformation
• Sequence Generator Transformation
• Rank Transformation
• Router Transformation
• Aggregator Transformation
• Joiner Transformation
• Stored Procedure Transformation(Connected & Unconnected)
• Union Transformation
• XML Transformation
• Mapping Wizards
• Implementing Type-I, Type-II, Type-III Mappings


Informatica-Workflow Manager
• Workflow Introduction
• Tasks
• Workflow tools
• Connections
• Defining tasks
(i) Command tasks
(ii) Email Task
(iii) Session Task
(iv) Link Conditions
(v) Event Wait & Event Raise
• Setting Properties of Session Task
• Creating Workflow
• Starting Workflow
• Monitoring Workflow


Informatica Advanced Features
• Incremental Aggregation
• Mapplet Implementation
• Target Load Plan
• Constraint Based Loading
• Mapping Parameters
• Mapping Variable
• Session Parameters
• Link Conditions
• Reusable Transformation
• Task and Types of Tasks
• Work let and types of work lets
• Scheduling Workflow
• Control flow using command task and event wait task
• Perform testing ETL
• Unit Testing ETL
• System Testing ETL
• Incremental Loading
• Performance Tuning
• File Repository

Contact : David
PH : +91-810-680-5188
E : [email protected]