Informatica

Informatica Training 

Introduction:

Informatica is widely used ETL tool for extracting the source data and loading it into the target after applying the required transformation.

Course Description:

1.Datawarehousing Concepts:

  • Introduction
  • Definitions
  • SDLC of DWH project
  • Datamarts(Dependent and Independent)
  • Dimensional Modelling Different Types of Schemas.
  • Definition of Dimension and Types
  • Definition of Fact and Types
  • SCD-1, SCD-2, SCD-3 Concepts.

2.Informatica

  • Informatica Installation
  • Informatica Architecture
  • Oracle Installation
  • ODBC and Relational Connections
  • Transformations
    1. Sorter
    2. Rank
    3. Filter
    4. Router
    5. Expression
    6. Aggregator
    7. Joiner
    8. Lookup
    9. Union
    10. Source qualifier
    11. SQL
    12. Seq generator
    13. Update Strategy
    14. XML
    15. Mapplet I/P,Mapplet O/P

3.Implemantaions:

  • Slowly Changing Dimension – 1 Practical
  • Slowly Changing Dimension -2 Practical
  • Dynamic Cache Practical
  • Working with Flat files
  • Mapping Variables and parameters
  • Shared folder and Shortcuts
  • Version control
  • File Repository OR
  • File List
  • Tracing levels and differences
  • Session Properties
  • Workflow Properties
    1. Touch File
    2. Event wait Task
    3. Timer Task
    4. Email task
    5. Event Raise Task
    6. Command Task
    7. Control Task
  • Worklets/Mapplets
  • Interview Questions
  • Course Material
  • Preparation of Resume.
  • Job Support.

 

Comments are closed