Informatica

* Informatica Concepts

o Basic Concepts o Key Terms
o Product Architecture
o Various Tools and thier roles
o Power Center vs Power Mart
o Informatica Server Configuration

* Informatica Designer

o Basic Concepts o Using the Designer
o Working With Sources
o Working with Flat Files, Targets
o Mappings, Transformations, Mapplets
o Working with Debugger
o Implementing Type I , Type 2 , Type 3 mappings
o Loading the Data into different Fact Tables

* Transformations

o Aggregator Transformations o XML Transformations
o Expression
o Filter
o Joiner
o Loook up Transformations
o Rank, Router
o Sequence Generator
o Sorter Transformation
o Source Qualifier Transformation
o Stored Procedure Transformation
o Transaction Control Transformation
o Union Transformation
o Update Stretegy Transformation
o Connected vs Unconnected Transformations

* Workflow

o Understanding the Server Architecture
o Working with Workflows
o Working with task assignment, command, decision, control, eventraise, event wait, timer, email, session task
o working with work ltes
o working with sessions
o understanding commit points
o recovering data
o monitoring workflows
o using multiple servers
o log files
o row error logging
o session parameters
o using incremental aggregation

* Other Implementation Considerations

o Understanding the Server Architecture
o Working with Workflows
o Working with task assignment, command, decision, control, eventraise, event wait, timer, email, session task
o working with work ltes
o working with sessions
o understanding commit points
o recovering data
o monitoring workflows
o using multiple servers
o log files

Cloud Informatica
Anuhar Vista Residence,
Alkapoor Township,
Manikonda,
Near Gachibowli.
Hyderabad.
cloudinformatica@gmail.com
7396395709