Training on Informatica Development with oracle SQL!!

#Batch started with the informatica development with Oracle SQL #weekend /weekdays Batch.SS� 

Scope:

�?� Training on Informatica development, Oracle sql, agile process and UNIX basics.

�?� Weekend/weekdays Classes

�?� 2 Hrs each class ( 1 hrs theory and 1 hrs Practical )

�?� 25 Classes ( 50 hrs )

�?� For Fresher/experience any passed out students.

Informatica Training Syllabus

Data Warehouse Introduction

Power Center Components

• Designer
• Repository Manager
• Workflow Manager
• Workflow Monitor
• Power Center Admin Console

• Informatica Concepts and Overview

  • Informatica Architecture.

  Sources

  • Working with relational Sources
  • Working with Flat Files

  Targets

  • Working with Relational Targets
  • Working with Flat file Targets

  Transformations â?? Active and Passive Transformations

  • Expression
  • Lookup â??Different types of lookup Caches
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Aggregator
  • Source Qualifer
  • Update Strategy
  • Normalizer
  • Union
  • Stored Procedure
  • Slowly Changing Dimension

  o� � � SCD Type1

  o� � � SCD Type2 â?? Date, Flag and Version

  o� � � SCD Type3

  Workflow Manger

  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks

  o� � � Session

  o� � � Decision task

  o� � � Control Task

  o� � � Event wait task

  o� � � Timer task

  • Monitoring workflows and debugging errors

  Indirect Loading

  Constraint based load ordering

  Target Load plan

  Worklet ,Mapplet ,Resuable transformation

  Migration â??XML migration and Folder Copy.

  Scheduling Workflow

  Parameter and variables

  XML Source, Target and Transformations

  Performance Tuning

  • Pipeline Partition
  • Dynamic Partition
  • Pushdown optimization

  ETL/Informatica Development Content

  • Advanced SQL & PL/SQL
  • Data Warehouse Concepts
  • Informatica Tool Version 9.X and higher
  • Developing Informatica Mappings
  • Developing Sessions,Worklets, Workflows
  • Working with Parameter File
  • Working with Informatica Scheduler
  • Working with Heterogeneous sources and Flat files
  • Working with Complex real-time scenario
  • Optimizing Queries and Informatica Sessions
  • Informatica Admin Concepts
  • Big-Data Basics
  • UNIX Basics
  • Sample Projects and Assignments