Informatica Online for Novice by BoundTech Solutions

Informatica Training Program
Duration: 60 Hrs
Training Mode: Class Room/On-line
Training Methodology: Real-time Project oriented
Training Features:
1. Trainers from Corporate
2. Unlimited Lab facility
3. Valid Materials(Soft/Hard Copy)
4. Resume Preparation and Mock Interview
5. 100% Placement Assistance
Topics Covered
Introduction to Data Warehousing
Scope of Data warehouse project in business application
Data warehouse Architecture and Design
Slow Change Dimension 1
Slow Change Dimension 2
Slow Change Dimension 3
OLTP
OLAP
ODS
Master Table
Detail Table
Dimension Table
Fact Table
Data Mart
Passive and Active Transformers
DB Concepts
DML

DDL
DCL
JOINS
Informatica and Data warehousing
Informatica Architecture
Informatica Server
ETL concepts
Repository Manager
Creating Repository
Managing the Repository
ODBC DSN creation
Designing the ETL
Understanding The After-Design Scenario
Specifying the Database Connections
Advanced Informatica
Troubleshooting Informatica
Power Center Design
Source Analyzer
Warehouse Designer
Mapping Designer
Mapplets Designer
Transformations in Informatica
Importing sources and Targets
Source Qualifier Transformation
Filter Transformation
Expression Transformation
Aggregator Expression
Router Transformation
Union Transformation

Update Strategy Transformation
SQL Transformation
Lookup Transformation
Rank Transformation
Sequence Generator
Creating, Configuring and Linking Ports
Joiner Transformation
Sorter Transformation
Using Informatica Manager
Workflow Manager
Understanding Jobs and Scheduler
Session
Command Task
Email Task
Task Developer
Workflow Monitor
Session Logs
Workflow Logs
Informatica and Unix
Informatica and Teradata
Informatica and Salesforce.com