INFORMATICA TRAINERS REQUIRED IN ELEGANT IT SERVICES GOOD IN INDIA

Informatica Trainers required in elegant it services good salary based on quality training After successfully completing this course, students should be able to: • Use PowerCenter 9.x Designer to build mappings that move data from sources to targets • Use PowerCenter 9.x Workflow Manager to build and run a workflow that runs a session based on a mapping • Design mappings and workflows based on business needs • Perform basic troubleshooting of PowerCenter mappings and transformations • Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 9 • Introducing the need of ETL • Overview of Informatica Architecture • Client tools and Server tools and Create,Manage and Edit Objects • Powercenter Designer • Importing Source file/Target File (Fixed width, Delimted) and File Properties • Build mapping to load data from flat files • Powercenter Workflow Manager and Monitor • Session Properties • Creation of Workflow Task (Session) and use it Workflow • Lab – Importing File Definition Using Designer • Lab Session • Transformation Overview • Transformation data types • Source Qualifier • Source Qualifier Transformation • Source Qualifier Properties • ASource Qualifier Joins • Source Pipelines • Using Sorted Ports • Lab Session Expression Transformation • Expression Editor • Ports (Input, Output and Variable) • Transformation Function Overview • Lab Session Filter Transformation • Filter Properties • Difference between Source Qualifier Filter and Filter Transformation • Lab Session Router Transformation • Overview • Working with Groups • Working with Ports • Connecting Router Transformations in a Mapping • Creating a Router Transformation • Difference between Router and Filter • Lab Session Sorter and Aggregator • Sorter, Aggregator and Self Join • Sorter Transformation • Aggregator Transformation • Active and Passive Transformations • Data Concatenation • Self-Join • Lab Session Rank Transformation • Overview • Ports in a Rank Transformation • Defining Groups • Creating a Rank Transformation • Lab Session Joiner Transformation • Joins, Features and Techniques I • Joiner Transformation • Shortcuts • Lab Session Union Transformation • Working with Groups and Ports • Creating a Union Transformation • Using a Union Transformation in a Mapping • Debugger & Debugging Mappings • Lab Session Lookups and Reusable Transformations • Lookup Transformation • Reusable Transformations • Lookup Caching • Lab Session Sequence generator Transformation • Overview • Common Uses • Sequence Generator Ports • Transformation Properties • Creating a Sequence Generator Transformation • Lab Session Load Strategies • Truncate and Load • Insert Only • Update Only • Update else Insert/Insert Else Update • Lab Session Update Strategy and Overrides • Update Strategy Transformation • Expression Default Values • Source Qualifier Override • Target Override • Session Task Mapping Overrides • Lab Session Working with SCD Type1 and Type2 • Introducing SCDs, type 1, 2 & 3 • Implementing type 1 • Implementing type 2 • Lab Session Dynamic Lookup and Error Logging • Dynamic Lookup • Error Logging • Unconnected Lookup • Unconnected Lookup Transformation • Lab Session Working with Sessions • Editing a Session • Using Pre- and Post-Session SQL Commands • Using Pre- and Post-Session OS Commands • Validating a Session • Stopping and Aborting a Session • Working with Session Parameters • Mapping Parameters and Variables in Sessions • Assigning Parameter and Variable Values in a Session • Lab Session Workflow Variables and Tasks • Link Conditions • Workflow Variables • Assignment Task • Decision Task • Email Task • Event Raise Task • Event Wait Task • Command Task • Reusable Tasks • Reusable Session Configuration • Lab Session Overview of Informatica Basic Administration, Roles & Responsibilities Covers the Performance tuning Techniques, new transformations..and migration of objects from one Folder/Environment to another environment Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly O