Informatica Online Training.

Enquire.Join and get training by Well Experienced & Certified tutors for your professional Courses.

Watch Sample Session!

INFORMATICA COURSE – LEARN @ YOUR CONVENIENCE

1.Introduction to Datawarehousing

  1. Data Warehousing Concepts
  2. Dataware housing (what/Why/How)
  3. Data Modelling(Schemas, FACTS and DIMENSIONS)
  4. Slowly Changing Dimensions
  5. Metadata

2. Power Center Components

  1. Designer
  2. Repository Manager
  3. Workflow Manager
  4. Workflow Monitor

3. Informatica Concepts and Overview

  1. Informatica Architecture.
  2. Source Qualifier
  3. Target Designer
  4. Transformations
  5. Mappings
  6. Mapplets
  7. Sessions
  8. Tasks

4. Sources

  1. Working with relational Sources
  2. Working with Flat Files

5. Targets

  1. Working with Relational Targets
  2. Working with Flat file Targets

6. Transformations

  1. Expression Transformation
  2. Lookup Transformation
  3. Sequence Generator Transformation
  4. Filter Transformation
  5. Joiner Transformation
  6. Sorter Transformation
  7. Procedural Transformation
  8. Router Transformation
  9. Aggregator Transformation
  10. Update Strategy Transformation
  11. Union Transformation
  12. Rank Transformation
  13. Transaction Control Transformation
  14. Normalizer Transformation
  15. Source Qualifier Transformation
  16. Stored Procedure Transformation
  17. XML Source Qualifier Transformation
  18. Debugging Mappings

7. ADVANCED INFORMATICA CONCEPTS

  1. Unconnected lookup Transformation
  2. Mapplet a
  3. Defining Reusable Transformations.
  4. Tasks And Types of Tasks.
  5. Worklet
  6. Scheduling Work flow
  7. Target Load Plan
  8. Types of Batch Processing
  9. Link conditions
  10. Mapping Parameters
  11. Mapping Variables
  12. Defining Session Parameters
  13. PMCMD Utility

8. TYPES Of LookUp Caches

  1. Static LookUp Cache
  2. Dynamic LookUp Cache
  3. Perisistance lookup Cache
  4. Shared LookUp Cache

9. Task Types:

  1.  Session
  2.  Command
  3.  EMAIL
  4.  Timer
  5.  Event Wait
  6.  Event Raise
  7.  Decision
  8.  Assignment
  9.  Control
  10.  Worklet