Training is designed in such a way so the trainee gets good command on fundamental and advanced concepts of Informatica PowerCenter which includes real time scenarios,assignments, online tests,best practices ,user friendly complete documentation completely in practical oriented. Duration:: 25 Hours Session Timings:: * Weekday Batches: (Mon - Fri) Any one hour in the below mentioned timings as per the slot availability Morning Hours: 04:00 AM - 08:00 AM IST Evening Hours: 06:00 PM - 11:00 PM IST

Topics Covered

Level-1 Data Warehousing Basic Concepts What is Data Warehouse What is Data warehousing? Characteristics of Data warehouse Principles of Data warehouse. Benefits of DWH. What is Data scrubbing, Data Transformation etc What is online transactional systems (OLTP) Difference between OLTP and DWH. Approaches of Data warehousing. DWH Lifecycle Data Warehouse Modeling Staging Area Dimension table Fact Table Schemas Star schema Snowflake schema Slowly changing Dimension Concepts SCD-1 SCD-2 SCD-3 Data Mart Top down Approach Top UP Approach Level-2 Introduction Sources Targets PowerCenter Repository PowerCenter Client Components Power Center Server Components PowerCenter Designer Repository Manager Workflow Manager Workflow Monitor PowerCenter Repository Service PowerCenter Integration Service Getting Started Using the PowerCenter Client /Workflow/Monitor/Repository Informatica architecture component wise Use of ODBC/Relational Connection Software Installation and Administrator Connecting to the Repository Creating a Folder Changing Password Creating Source Definitions Creating Target Definitions and Target Tables Creating Target Definitions Creating a Mapping Creating Transformations Creating Sessions and Workflows Configuring Relational Connection in the Workflow Manager Creating a Workflow Running and Monitoring Workflows Fetching Session Log Getting Run Properties Working With Files (Source/Target) Working with Fixed width files Working with Delimited files Working with XML Files Level-3 Definition of Transformation Types of Transformation Active/Passive Transformation Reusable and Non-Reusable Transformation Filter Transformation Router Transformation Expression Transformation Rank Transformation Sorter Transformation Aggregator Transformation Sequence Generator Transformation Joiner Transformation Union Transformation Update Strategy Transformation Lookup Transformation Stored Procedure Transformation Normalizer Transformation Source Qualifier Transformation Transaction Control Transformation XML Source Qualifier Transformation JAVA Transformation Unconnected Stored Procedure Transformation Unconnected Lookup Transformation Level-4 Working with Parameters/Variables Scheduling Debugging Session Properties Error Handling Analyzing Workflow and Session Logs Performance Tuning Unit Testing Export/Import (Backup/Restore) User Defined Function Worklet Reusable and Non Reusable Sessions Implementing SCD1, SCD2, SCD3 Task Reusable and Non Reusable Task Session Task Command Task Email Task Decision Task Assignment Task Timer Task Event Wait Task Event Raise Task Control Task Link Task Partitioning Push Down Optimization (PDO) Target Load Plan Constraint Based Load Ordering ETL Life Cycle

Who should attend

Any one

Pre-requisites

- I will also cover all the Pre-requisites, i.e, SQL & Unix - Good internet connectivity

What you need to bring

Regular practice is expected

Key Takeaways

- Conceptes of DWH - Strong ETL knowledge - Able to create complex mappings - Good knowledge of Transformations - Advanced ETL concepts