Informatica Online Training Institute in Ameerpet Hyderabad
Revanth Technologies provides Informatica Online Training in Ameerpet by real time Experts. For more information about Informatica online training in Ameerpet call 9290971883.
Informatica is software which allows the user to create a data warehouse with ease. It makes the process of designing, ETL and maintaining the data warehouse a breeze as well. The use of data warehousing is an innovative way for a business to lower their operating costs, raise the production rates and push their sales through the door by using the management of information. It allows for the support of intelligence through the business, management of the relationship with the customer plus lots of other beneficial business uses.
Introduction to Data warehousing
- What is Data warehousing?
- Who needs Data warehouse?
- Why Data warehouse is required?
- Types of Systems
(i) OLTP
(ii) DSS
- Maintenance of Data warehouse
- Data warehousing Life Cycle
- Data warehousing Testing Life Cycle
Data warehousing Architecture
- Source
- Integration Layer
- Staging Area
- Targets
- Analysis & Reporting
- ODS
Data Modeling
- Introduction
- Different phases of Modeling
Multi Dimensional Modeling
- What is a Dimension?
- What are Facts?
- Multi Dimensional Model
- Hierarchies
- OLAP
- MOLAP
- ROLAP
- HOLAP
- Cubes and its Functions
- Star Schema
- Fact Table
- Dimensional Tables
- Snow flake Schema
- Factless Fact Table
- Confirmed Dimensions
Informatica 8.6
Introduction to Informatica
- Overview
- Basic Definitions
- Informatica Products
- Informatica Architecture
- Tools and their roles
- Folders – Sub Folders
Informatica Designer – Introduction
- Introduction to designer
- Designer interfaces
- Designer tools
- Defining Sources
(i) Database as a source
(ii) Flat Files sources
- Defining Targets
(i) Importing from database
(ii) Creating a new target
(iii) 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 Transformations
- Source Qualifier Transformation
- SQL override in Source Qualifier Transformation
- Mapping Source Qualifier as 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 and unconnected Transformation
- Union Transformation
- XML Transformation
- Mapping Wizards
- Implementing Type-I, Type-II and Type-III mappings
Informatica Workflow Manager
- Workflow Introduction
- Tasks
- Workflow Tools
- Connections
- Defining Tasks
- Command Task
- Email Task
- Session Task
- Link Conditions (v) Event Wait & Event Raise
- Setting properties of Session Task
- Creating Workflow
- Starting Workflow
- Monitoring Workflow
Informatica Advanced Features
- Incremental Aggregation
- Mapping Analyst for Excel (MAE)
- Push-down Optimization
- Mapplet Implementation
- Target Load Plan
- Constraint Based Loading
- Mapping Parameters
- Mapping Variables
- Session Parameters
- Link Conditions
- Meta Data Backup & Restore
- Copying Repository
- Deleting Repository Contents
