Java training course is one of the most undeniably important programming languages that define the stratum of computer sciences. We are here to solve the scrawled question of Java courses in Chennai, by paving way to the paramount Java training institute in Chennai. gantryrocketNeither can you find a centre as excellent as ours nor can you build the developers like we have developed here. We don’t just develop Java experts; we build and recreate IT professionals for a better future in a global scenario. We connect to the students through web interface and a part of our training is completely digitalised, for making the students practically understand the programming language. When the classes are theoretical, we don’t hurdle up there, there are practical sessions that help the learners learn an epoch regarding Java. While we ponder over Java, we also teach them the basics of other programming languages and help them grow from the scratch. SLA deals with a huge lot of technologically advanced and empirically selected system of education that aids the holistic development of a candidate. Placement, being our forte, we delve into not just growth, but setting a high pedestal for a lifetime.

Informatica Course Syllabus

Data Warehousing Concepts

  • Data Warehouse
  • Data Mart
  • OLAP VS OLTP
  • Data Warehouse Architecture (Basic)
  • Data Warehouse Architecture (with a Staging Area)
  • Dimensional Modeling
  • Star Schema
  • Snowflake Schema
  • Dimension
  • Fact
  • Slowly Changing Dimension(Type 1,2 and3)
  • Hierarchy
  • Confirmed Dimension
  • Fact less Fact Table.
  • Summary / Aggregations table
  • Change Data capture
  • Power Center Components

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

  • Informatica Architecture.
  • Source Qualifier
  • Target Designer
  • Transformations
  • Mappings
  • Mapplets
  • Sessions
  • Tasks
  • Sources

  • Working with relational Sources
  • Working with Flat Files
  • Targets

  • Working with Relational Targets
  • Working with Flat file Targets
  • Transformations

  • Expression Transformation
  • Lookup Transformation
  • Sequence Generator Transformation
  • Filter Transformation
  • Joiner 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
  • XML Source Qualifier Transformation
  • Debugging Mappings
  • Power Center Transformation Language

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

  • Unconnected lookup Transformation
  • Unconnected Stored Procedure to Create and Drop Index
  • Mapplet and Types of Mapplets
  • Defining Reusable Transformations.
  • User Defined Functions
  • Tasks And Types of Tasks
  • Worklet and Types of Worklets
  • Scheduling Work flow
  • Constraint Based Load Ordering
  • Target Load Plan
  • Types of Batch Processing
  • Link conditions
  • Mapping Parameters
  • Mapping Variables
  • Defining Session Parameters
  • Session Recovery
  • Difference Between Normal and Bulk Loading
  • Push Down Optimization
  • PMCMD Utility
  • PMREP Utility
  • Incremental Aggregation
  • TYPES Of LookUp Caches

  • Static LookUp Cache
  • Dynamic LookUp Cache
  • Persistence lookup Cache
  • Shared LookUp Cache
  • Sorter and Rank Cache
  • Task Types

  • Session
  • Command
  • EMAIL
  • Timer
  • Event Wait
  • Event Raise
  • Decision
  • Assignment
  • Control
  • Worklet
  • ETL Testing

  • UNIT Testing
  • System Integration testing
  • PERFORMANCE TESTING
  • ETL Performance Optimization techniques

  • Enquire Now