Pay Fees After Satisfaction With Interview Guidence

Informatica Syllabus

Data Warehousing Concepts
  • Data Warehouse(Basic)
  • Data Mart
  • OLAP VS OLTP
  • Data Warehouse Architecture (with a Staging Area)
  • Dimensional Modelling : 1)Star Schema 2)Snowflake Schema
  • Dimension
  • Slowly Changing Dimension(Type 1,2 )
  • Fact: : Additive Fact, Semi Additive Fact, Fact less Fact Table.
  • Change Data capture
  • Power Centre Components

  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Informatica Concepts and Overview

  • Informatica Architecture
  • Source Qualifier
  • Target Designer
  • Transformations
  • Mappings
  • Mapplets
  • Sessions
  • Tasks
  • Power Centre Components

  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Sources

  • Working with relational Sources
  • Working with Flat Files
  • Target Designer
  • Transformations
  • Mappings
  • Mapplets
  • Sessions
  • Tasks
  • Targets

  • Working with Relational Targets
  • Working with Flat Files
  • for working peopleDownload

    Transformations
  • Expression Transformation
  • Lookup Transformation
  • Sequence Generator Transformation
  • Filter Transformation
  • Joiner Transformation
  • Sorter Transformation
  • Sorter Transformation
  • Procedural Transformation
  • Router Transformation
  • Aggregator Transformation
  • Update Strategy Transformation
  • Union Transformation
  • Rank Transformation
  • Transaction Control Transformation
  • Normalizer Transformation
  • Source Qualifier Transformation
  • Stored Procedure Transformation

    Power Centre Transformation Language

  • Numeric functions
  • String Functions
  • Date Functions
  • Conversion Functions
  • Aggregate Functions
  • User Defined Functions
  • ADVANCED INFORMATICA CONCEPTS

  • Unconnected lookup Transformation
  • Unconnected Stored Procedure to Create and Drop Index
  • Mapplet
  • User Defined Functions
  • Tasks And Types of Tasks
  • Worklet
  • Scheduling Work flow
  • Target Load Plan
  • Link conditions
  • Mapping Variables
  • Defining Session Parameters
  • Session Recovery
  • Difference Between Normal and Bulk Loading
  • Push Down Optimization
  • TYPES Of Look Up Caches

  • Static LookUp Cache
  • Dynamic Look Up Cache
  • Persistence lookup Cache
  • Shared LookUp Cache
  • Interview Preparation
  • Personal Interview
  • Group Discussion
  • Our Courses

  • C/C++ RS: 3500
  • CORE JAVA, J2EERS: 5500
  • HTML5,CSS3,JQUERY,PHPRS: 6000
  • WordpressRS: 5000
  • C SHARPRS: 4500
  • ASP.NETRS: 5000
  • AndroidRS: 7000
  • Angualr JsRS: 6000
  • ASP Dot Net MVCRS: 8000
  • Unix/LinuxRS: 5000
  • Oracle(SQl)RS: 4000
  • Oracle(PL/SQl)RS: 5000
  • InformaticaRS: 12000
  • Jquery & Java ScriptRS: 4000
  • Spoken EnglishRS: 4000
  • Aptitude RS: 4000