Informatica ppt | Informatica Online Training in hyderabad | Informatica Certification | Informatica tutorials

1
Informatica Online Training

• SRY IT SOLUTIONS
• Call 91 9948030675(IND)
• 1-319-804-4998(USA)

2
Introduction

• SRY IT Solutions is specialized in Online
  training, End-to-End Project Support and
  Placement Assistance services. We are having
  ample of experience in SAP, Oracle, Other Online
  Trainings. In SAP we handle both technical
  modules like SAP BW 7.3,SAP HANA,SAP BO, SAP BO
  Admin and functional modules like SAP MM/WM,SAP
  SD,SAP FI/CO etc.

3
Course Content

• INTRODUCTION TO DATAWAREHOUSING
• Data Warehousing Concepts
• Dataware housing (what/Why/How)
• Data Modelling(Schemas, FACTS and DIMENSIONS)
• Slowly Changing Dimensions
• Metadata
• POWERCENTER COMPONENTS AND USER INTERFACE
• PowerCenter Architecture
• PowerCenter Client Tools
• Lab â Using the Designer and Workflow Manager

4
Course Content

• SOURCE QUALIFIER
• Source Qualifier Transformation
• Lab Project Overview
• Lab A â Load Payment Staging Table
• Source qualifier Joins
• Lab B â Load Product Staging Table
• Source Pipelines
• Lab C â Load Dealership and Promotions Staging
  Table and Real time issues
• EXPRESSION, FILTER, FILE LISTS AND WORKFLOW
  SCHEDULER
• Expression Editor
• Filter Transformation
• File Lists
• Workflow Scheduler
• Lab â Load the Customer Staging Table and Real
  time issues

5
Course Content

• JOINS, FEATURES AND TECHNIQUES I
• Joiner Transformation
• Shortcuts
• Lab A â Load Sales Transaction Staging Table
• Lab B â Features and Techniques I and Real time
  issues
• LOOKUPS AND REUSABLE TRANSFORMATIONS
• Lookup Transformation
• Reusable Transformations
• Lab A â Load Employee Staging Table
• Lab B â Load Date Staging Table and Real time
  issues
• DEBUGGER
• Debugging Mappings
• Lab â Using the Debugger

6
Course Content

• SEQUENCE GENERATOR
• Sequence Generator Transformation
• Lab â Load Date Dimension Table and Real time
  issues
• LOOKUP CACHING, MORE FEATURES AND TECHNIQUES
• Lookup Caching
• Lab A â Load Promotions Dimension Table
• Lab B â Features and Techniques II
• Review and more Lab Activities and Real time
  issues
• ROUTER, UPDATE STRATEGY AND OVERRIDES
• Router Transformation
• Update Strategy Transformation
• Expression Default Values

7
Course Content

• Source Qualifier Override
• Target Override
• Session Task Mapping Overrides
• Lab â Load Employee Dimension Table and Real
  time issues
• DYNAMIC LOOKUP AND ERROR LOGGING
• Dynamic Lookup
• Error Logging
• Lab â Load Customer Dimension Table
• UNCONNECTED LOOKUP, PARAMETERS AND VARIABLES
• Unconnected Lookup Transformation
• System Variables
• Mapping Parameters and Variables
• Lab â Load Sales Fact Table

8
Course Content

• SORTER, AGGREGATOR AND SELF-JOIN
• Sorter Transformation
• Aggregator Transformation
• Active and Passive Transformations
• Data Concatenation
• Self-Join
• Lab â Reload the Employee Staging Table and
  Real time issues
• SCD type1 â LAB
• SCD type2 â LAB
• SCD type3 â LAB

9
Course Content

• MAPPLETS
• Mapplets
• Lab â Load Product Daily Aggregate Table
• Review and more Lab Activities and Real time
  issue
• WORKFLOW VARIABLES AND TASKS
• Link Conditions
• Workflow Variables
• Assignment Task
• Decision Task
• Email Task
• Lab â Load Product Weekly Aggregate Table

10
Offered Other Modules

• SAP SAP BPC, BASIS, ABAP, BO, ADMIN, FICO, MDM,
  CRM, HANA, FSCM, IS UTILITIESBO DATA SERVICES,
  APO. etc
• DWH AB INITIO TRAINING, AJAX , INFORMATICA,
  DATA STAGE , HANDOOP , WEBSPHERE.

11
Contact us for free demo details and Session
Schedules atUSA 1-319-804-4998 INDIA
91-9948030675Email info_at_sryitsolutions.comWeb
www.sryitsolutions.com