Informatica Online Training Provided By MaxMunus Solutions Pvt Ltd in Abilene, Texas For Sale

Module 1: Basics of Data Warehousing
? Overview of an OLTP system, Pros/Cons of OLTP system
? Needs and Definitions of a Data Warehouse
? Difference between OLTP and OLAP systems
? Concept of ODS (Operational Data Store) and Data Marts
? Role of ETL in data warehousing
? ETL process ? Extract, Transform and Load
? Design Approaches ? Top Down and Bottom Up
? Logical v/s Physical models
? Star and Snowflake schemas
? Dimensional modeling
? Facts and Dimensions
? Granularity
? Modeling using ER diagrams
Module 2: Power Center 9 Administration
? Introduction to Informatica
? Power Center 9 Architecture
? Power Center components
? Power Center client
? Repository Manager
? Designer
? Workflow Manager
? Workflow Monitor
? Repository, Integration and Application Services
? Service Manager
? Concept of Domain, Nodes and Grids
? Power Center Administration Console
Module 3: Repository Manager
? Connecting to the repository
? Creating Repository Users and Groups
? Assigning Privileges to a group
? Creating folders and assigning folder permissions
Module 4: Designer and Workflow Manager
? Overview of Mappings
? Overview of Transformations
? Overview of Tasks
? Overview of Workflows
? Metadata
? Power Center client tools ? Designer and Workflow Manager
Module 5: Working with Transformations
? Source Qualifier Transformation
? Expression Transformation
? Filter Transformation
? File Lists
? Workflow Scheduler
? Joiner Transformation
? Shortcuts
? Connected Lookup Transformations
? Reusable Transformations
? Debugger
? Sequence Generator Transformation
? Lookup Caching
? Sorter Transformation
? Aggregator Transformation
? Self Join
? Router Transformation
? Update Strategy Transformation
? Overriding Techniques
? Dynamic Lookup Cache
? Error Logging
? Unconnected Lookup Transformations
? System Variables, Mapping Parameters and Variables
? Mapplets
Module 6: Working with Workflows
? Workflow Variables
? Link Conditions
? Assignment Task
? Decision Task
? Email Task
? Event Wait Task
? Event Raise Task
? Command Task
? Reusable Tasks and Reusable Session Tasks
? Reusable Session Configurations
? pmcmd Utility
? Worklets
? Timer Task
? Control Task
Module 7: Performance Tuning
? Identifying Bottlenecks
? Optimizing the Source and the Target
? Optimizing Mappings
? Optimizing Transformations
? Using Incremental Aggregation
? Optimizing Sessions
? Using Pushdown Optimization
? Using Pipeline Partitions
? To join Online Training session kindly feel free to contact with us
? Name ? Nitesh Kumar
? Email - id ? nitesh@maxmunus.com
? Contact No. - +91 - xxxxxxxx23
Company Website - http://www.maxmunus.com