it is an Advanced IT Course

Topics Covered

course content for informatica online training and class room training Introduction to Information Overview Basic Definitions Informatica Products Informatica Architecture Tools and their roles Folders -sub Folders Power Center I Power Malt Informatica Designer -Introduction Introduction to designer Designer interfaces Designer tools Defining Sources (i) Database as a source (ii) Rat Flies sources Defining Targets Importing from database Creating a new target 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 Transformation Source Qualifier Transformation SQlOverride-Source Qualifier Transformation Mapping Source Qualifier as Filter Source qualifier to join Data Filter Transformation Expression Transformation SequenceGenerator Transformation Rank Transformation Router Transformation Aggregator Transformation Joiner Transformation Stored procedure Transformation (Connected & Unconnected) Union Transformation XMl Transformation Mapping Wizards Implementing Type-I, Type-II, Type-III Mappings Informatica - Workflow Manager Workflow Introduction Tasks Workflow tools Connections Defining tasks Command Task Email Task Session Task Link Conditions Event Wait & Event Raise Setting Properties of Session Task Creating Workflow Starting Workflow Monitoring Workflow Informatica Advanced Features Incremental Aggregation Mapplet Implementation Target Load Plan Constraint based Loading Mapping Parameters Mapping Variables Session parameters Link Conditions

Who should attend

Any Graduate

Pre-requisites

Basic Computer Skills

What you need to bring

Nothing

Key Takeaways

Excellent core skills about Informatica