Informatica1

Learn Informatica

Informatica online training is designed to explain that Informatica is a widely used ETL tool for extracting the source data and loading it into the target after applying the required transformation.

Informatica enables organizations to gain a competitive advantage in today’s global information economy by empowering companies with timely, relevant and trustworthy data for their top business imperatives.

Informatica course provides data integration software and services for businesses.
As an Informatica online training expert we offer a comprehensive portfolio of training on a variety of Informatica solutions.

With our expertise in the field of online IT training globally, we provide you Informatica training customized to your needs.

INFORMATICA 9.0


Introduction to Data warehousing
• What is data warehousing?
• Who needs Data warehousing?
• Why data warehousing required?
• Types of systems?
• Maintenance of Data warehouse?
• Data warehousing life cycle?
• Data warehousing Testing Life Cycle.
Data warehousing Architecture
• Source
• Integration layer
• Staging layer
• Targets
• Analysis & Reporting
• ODS
• HPQS
Multi-Dimensional Modeling
• What is Dimension?
• What are facts?
• Multi-Dimensional Model
• Hierarchies
• OLAP
• MOLAP
• ROLAP
• HOLAP
• Cubes and its Functions
• Star Schema
• Dimensional Tables
• Snow Flake Schema
• Fact less Fact table
• Confirmed Dimensions
Informatica 8.6.0
1. Introduction
• Over view
• Basic Definitions
• Informatica Products
• Informatica Architecture
• Tools and their roles
• Folders-Sub Folders
• Power Centre / Power Marts
2. Informatica designer – introduction
• Introduction to Designer
• Logon to Designer
• Designer Interfaces
• Designer Tools
• Defining Sources
 Database as a Source
 Flat file sources
• Defining Targets
• Importing from database
• Creating a new target
• Creating target database objects

3. Informatica Designer
• Mapping Introduction
• Source Qualifier
• Ports
• Mapping – Table to Table
• Mapping Flat file to Table
• Connected/Unconnected Transformations
• Active and Passive Transformations
• SQL override-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-1,Type-II,Type-III mappings
4. Informatica-Workflow Manager
• Workflow Introduction
• Tasks
• Workflow tools
• Connections
• Defining Tasks
 Command Tasks
 Email Task
 Session Task
 Link Conditions
 Event Wait & Event Raise
• Setting Properties of Session Task
• Creating Workflow
• Starting Workflow
• Monitoring Workflow
5. 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.

Enquiry for online demo

CosQube video training

CosQube news

To all recruitment agencies: IBM only accepts resumes from agencies on our Approved Agency List. Please do not forward resumes to our applicant tracking system, IBM employees, or send to any IBM company location. IBM is not responsible for any fees related to unsolicited resumes.
On news title click users will redirect to this url.On news title click users will redirect to this url.On news title click users will redirect to this url.
On news title click users will redirect to this url.On news title click users will redirect to this url.On news title click users will redirect to this url.