INFORMATICA TRAINING

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


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

Need Creative Consulting Solutions to improve your business Presence ?

Propel Solutions provides customized consulting and support services to the clients across the globe. Our highly experienced team enables us to provide 24/7 support services to the clients. Our consulting and support services are 100% focused and secured.