Informatica Course Content 3w1o27

Informatica Power Center Training - 50 Hours - $500 per student Empire Data Systems - #1 Database Training hose in USA!!! www.empiredatasystems.com

General information about the course

Next batch starts on December 12th, 2012      

Most comprehensive Informatica Power Center course with Hands-On lab exercise in USA. Trained by MASTER Informatica Developer and with 5+ year’s industry experience. Total duration of the course is 50 hours. Course fee is $500 per student. Course schedule is Monday to Friday 8:00PM to 10:30 PM Eastern Time. After each class, you will get  Excellent course material.  Hands-On LAB exercises which you need to finish before next class.  Recorded video of the live class which you can keep it forever and review it later.

See our comprehensive course content below… Believe me, you will not be disappointed!!! About the trainer Swathi is an expert in Informatica PowerCenter space, whether as a developer or role. She is well experienced in mapping for very complex ETL logic using almost every transformation. She is comfortable in almost every corner of PowerCenter -- mapplet, reusable transformation, session and various other tasks, work lets, workflow, optimization, error handling, re-runnablity of workflow, installing of power center server/client, creating domain/repository/integration service/web service, restore/backup of repository and much more. Overall, she is having 5+ years of IT experience in Oracle 9i/10g, MySQL, Informatica PowerCenter 7.1.3/8.6/9.1

Information

Daniel AG - Founder + Master DBA (267.718.1533) Empire Data Systems LLC- #1 Database Training House in USA!!! www.empiredatasystems.com - Website www.linkedin.com/in/danielthedba - LinkedIn www.youtube.com//EmpireDataSystems - YouTube Channel daniel.ag.philly - Skype "Get trained from the MASTER!!!"

Informatica Course Content

Data Warehouse Concepts 1.1 Introduction to Data warehouse 1.2 What is Data warehouse and why we need Data warehouse 1.3 OLTP vs OLAP vs Data warehouse 1.4 Star schema/Snowflake schema/Galaxy schema 1.5 Dimensions / Facts tables. 1.6 Slowly Changing Dimensions and its types. 1.7 Data Mart vs Data warehouse Introduction and Architecture 1.1 ETL (Extract-transform-load) Overview 1.2 Informatica PowerCenter as an ETL tool. 1.3 Architecture and Software Overview 1.4 Definition of Domain, Repositories, Integration Services.

1.5 Metadata Introduction 1.6 Overview of Informatica PowerCenter istration Console. Installation 2.1 Informatica PowerCenter and Oracle database. 2.2 Install PowerCenter Server and Client. 2.3 Informatica Power Center Installation directories. Client Software Overview 3.1 Introduction to Designer Interface 3.2 Introduction to Workflow Manager Interface 3.3 Introduction to Workflow Monitor 3.4 Introduction to Repository Manager 3.5 Nature of ODBC in the Designer 3.6 Software Demonstration Source Object Definitions 4.1 Flat File Sources 4.2 Relational Sources 4.3 Data Previewer 4.4 LAB: Import a Source 4.5 LAB: Create a Source manually. Target Object Definitions 5.1 Target Definitions 5.2 Target Properties 5.3 Flat File Targets 5.4 Relational Targets 5.5 LAB: Import a Target 5.6 LAB: Create a Target, manually. Mappings 6.1 Defining a Data Flow Diagram 6.2 Transformation Objects and Views 6.3 Source Definition and Source Qualifier 6.4 Pre-SQL and Post-SQL Rules 6.5 Expression Transformation 6.6 Informatica Functions 6.7 Variable Ports 6.8 Data Types 6.9 Mapping Validation 6.10 LAB: Create a Working Mapping Workflows 7.1 Workflow Tools 7.2 Workflow Structure 7.3 Workflow Connections 7.4 Workflow Tasks 7.5 Workflow Design Process 7.6 Workflow Properties 7.7 Workflow Links 7.8 Session Tasks 7.9 LAB: Configure a Workflow and Session. And call previously created mapping. 7.10 LAB: Command line execution of a workflow. Monitoring Workflows

8.1 Workflow Monitor Views 8.2 Monitoring a Server 8.3 Actions Initiated from the Workflow Monitor 8.4 Filtering Views 8.5 LAB: Run and Monitor the Workflow. View Logs and summary load information. 8.6 LAB: Demonstration of Designer Features Debugger 9.1 Debugger Features 9.2 Debugger Windows and Indicators 9.3 Debugger Best Practices 9.4 LAB: Debug a Mapping Transformation 10.1 What is a transformation in Informatica PowerCenter space? 10.2 Active and ive transformation Source Qualifier 11.1 Source Qualifier transformation Overview 11.2 Use of source qualifier to restrict data read from source. Expression Transformation 12.1 Expression Functionality 12.2 Use of a Variable port to hold previous row value. 12.3 Few common extression – IF-ELSE, ISNULL, etc 12.4 LAB: Create a Expression Transformation, Run Workflow Filter Transformation 13.1 Filter Functionality 13.2 Filter Properties 13.3 Filter Versus DB Where Clause 13.4 LAB: Create a Filter Transformation, Run Workflow Sorter Transformation 14.1 Sorter Functionality 14.2 Sorter Properties 14.3 Sorter Versus Database Order by Clause 14.4 LAB: Use Sorter transformation in a mapping Aggregator Transformation 15.1 Aggregator Transformation 15.2 Aggregator Expressions and Functions 15.3 Using Unsorted and Sorted Data 15.4 Data Flow Rules 15.5 Aggregator Versus Database Group By 15.6: LAB : Use aggregator in a mapping. er Transformation 16.1 Homogeneous and Heterogeneous s 16.2 er Conditions and Properties 16.3 er Usage 16.4 Types of s 16.5 er Versus Database 16.6 LAB: Add Sorter, er, and Aggregator Lookup Transformation

17.1 Lookup Principles 17.2 Lookup Properties 17.3 Lookup Caching 17.4 Lookup Versus Database 17.5 LAB: Create a Basic Lookup 17.6 Connected Lookup Vs Unconnected Lookup Unconnected Lookups 18.1 Usage and Techniques 18.2 Advantages 18.3 Functionality 18.4 Conditional Lookups 18.5 LAB: Create an Unconnected Lookup Update Strategy Transformation 19.1 Update Strategy Transformation 19.2 Update Strategy Expressions 19.3 Update Strategy Best Practices 19.4 LAB: Create a Type 2 Dimension Update Router Transformation 20.1 Router Functionality 20.2 Router Groups 20.3 LAB: Use a Router to Delete Rows Sequence Generator Transformation 21.1 Sequence Generator Functionality 21.2 Sequence Generator Properties 21.3 Sequence Generator Best Practices 21.4 LAB: Create a Sequence Generator transformation in mapping. Normalizer Transformation 22.1 Normalizer Transformation Functionality 22.2 Theoretical Example of using normalizer in Cobol source. 22.3 LAB: Create a mapping which uses normalizer transformation. Union Transformation 23.1 Overview of Union Transformation 23.2 Union transformation vs database union 23.3 LAB: Create a mapping which uses union transformation. Parameters and Variables 24.1 Parameter Scoping 24.2 System Variables 24.3 Mapping Parameters and Variables 24.4 Variable Functions Heterogeneous Targets 25.1 Heterogeneous Target Types 25.2 Target Type Limitations and Conversions 25.3 LAB: Build Heterogeneous Targets Mapplets 26.1 Mapplet Designer 26.2 Mapplet Advantages 26.3 Mapplet Types and Rules

26.4 Active and ive Mapplets 26.5 Mapplet Parameters and Variables 26.6 Mapplet Designer Best Practices 26.7 LAB: Build a Mapplet Reusable Transformations 27.1 Transformation Developer 27.2 Rules 27.3 Promoting and Copying Transformations 27.4 Transformation Developer Best Practices 27.5 LAB: Create and Use a Reusable Transformation Error Logging 28.1 Setting On and Off 28.2 Data Rejects with Error Logging Off 28.3 Error Logging to Database Table and Flat File 28.4 Source Row Logging 28.5 Error Logging Best Practice Architecture Workflow Configuration 29.1 Server Connections 29.2 Reusable Workflow Schedules 29.3 Reusable Session Configurations 29.4 LAB: Create a Sequential Workflow 29.5 LAB: Create a Concurrent Workflow Reusable Tasks 30.1 The Command Task 30.2 The Email Task 30.3 Reusable Task Best Practices Non-Reusable Tasks 31.1 The Decision Task 31.2 The Assignment Task 31.3 The Timer Task 31.4 The Control Task 31.5 The Event Wait Task 31.6 The Event Raise Task 31.7 Non-Reusable Tasks Best Practices 31.8 LAB: Create Event Wait/Event Raise and Timer 31.9 LAB: Create a Control and Assignment Task 31.10 LAB: Create a Command Line Task Worklets 32.1 Reusable Worklet 32.2 Non-Reusable Worklet 32.3 Worklet Best Practices Advance Topics (Theory) 33.1 Partitioning 33.2 Pushdown techniques 33.3 Optimization

Get trained from the MASTER!!!!! You will not be disappointed.

Call me now @267 718 1533 my course only if you are SERIOUS about learning Informatica This is a course run by a professional for other professionals.