Course Start Date

Informatica Online Training With Cognos Integration

 

We Give Corporate Training on Informatica with Cognos Integration and Also We will deploy Entire Software in Clients System So that Client don’t have to Depend on Server Access.

Introduction to Datawharehousing Video Demonstration

Introduction to Informatica Power Center Designer:-

Source Analyzer
Target Designer
Maplet Designer
Transformation Developer
Mapping Designer

Informatica Power Center Workflow Designer :-

Workflow Designer
Task developer
Work let Designer

Informatica Power Center Workflow Monitor

Transformations:-

Source Qualifier
Source Qualifier Join
Source Qualifier Filter
Expression
Connected Stored Procedure
Unconnected Stored Procedure
Sequence Generator
Aggregator
Filter
Lookup
Joiner
Router
Rank
Sorter
Transaction Control
Union Transformation
Xml Source Qualifier
Using Flat Files as Sources
Using Flat Files as Source and Target
Using XML Files as Source
Reading Data From Multiple Data Bases
Target Load Plan
Reusable Transformation
Reusable Session
Map let
Work let
Data type Conversions< /p>

Loading Strategy:-

Sequential Load
Parallel Load

Project:-

Mini Project

Introduction to Reporting Tool Cognos

Using the Project Created in Informatica In Cognos
Developing Few Reports in Cognos

Informatica Administration

Installation of Informatica
Installation of Oracle Database
Installation of SQL Server
Creation Repository
Creation of Users
Assigning Privileges to users
Creation of Groups
Adding the Repository to Informatica Repository Manager
Creating Work Space
Creating Security to Workspace
Creating Data source Connections
Configuration of Sql server and Oracle Database with Informatica
Scheduling the Workflow
Reusable Scheduling
Installation of Informatica on Linux