Informatica

Informatica ETL Technology has been the most in thing in the world from past 2-4 years. Informatica ETL Power Centre picked up its demand in recent times and now it is the most accepted and famous technology in the world of Business Intelligence (BI).

JMicro Technologies trainings in association with industry experts provides quality trainings to professionals.

COURSE OBJECTIVE

  • data integration: ETL, information lifecycle management, B2B data exchange, cloud data integration, complex event processing, data masking, data quality, data replication, data virtualization, master data management, ultra messaging.

WHO SHUOLD DO THIS COURSE

Database professionals, IT managers. Software developers, any IT professionals with an urge to learn Informatica can do this course

Prerequisite: -

Basic understanding of database management system & BI

  • Introduction to Informatica
  • Basic Definitions
  • Informatica Products
  • Informatica Architecture
  • Tools and their roles
  • Folders -sub Folders
  • Power Center I Power Malt
  • Introduction to designer
  • Informatica Designer -Introduction
  • Designer interfaces
  • Designer tools
  • Defining Sources
  • (i) Database as a source
  • (ii) Rat Flies sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database objects
  • Mapping Introduction
  • Informatica Designer
  • Source Qualifier
  • Ports
  • Mapping -Table to Table
  • Mapping flat File to Table
  • Connected/Unconnected Transformations
  • Active and Passive Transformation
  • Source Qualifier Transformation
  • SQl Override-Source Qualifier Transformation
  • Mapping Source Qualifier as Filter
  • Source qualifier to join Data
  • Filter Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored procedure Transformation (Connected & Unconnected)
  • Union Transformation
  • XMl Transformation
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III
  • Mappings
  • Workflow Introduction
  • Informatica - workflow Manager Task
  • Workflow tools
  • Connections
  • Defining tasks
  • (i) Command Task
  • (ii) Email Task
  • (iii) Session Task
  • (iv) Link Conditions
  • (v) Event Wait & Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
  • Incremental Aggregation
  • Informatica Advanced Features
  • Mapplet Implementation
  • Target Load Plan
  • Constraint based Loading
  • Mapping Parameters
  • Mapping Variables

Sign Up

Testimonials

  • Completed Big Data Hadoop Training from JMicro Technologies Trainings and get placed in American Express. The course material and the practical knowledge on all the frameworks of Hadoop helps me a lot during my interview and if anyone want to start their career in Hadoop then JMicro Technologies is no doubt the best institute to join.

    Shruti
    Big Data Hadoop - Placed in American Express
  • Its a wonderful opportunity to learn internet marketing from one of the best internet marketing expert

    Pawan Sehrawat
    Internet Marketing
  • JMicro Technologies Trainings is the best hadoop institute in chennai

    Manish
    Big Data Hadoop
  • The Training provided at JMicro Technologies is designed as per the current market need.After completion of the training from JMicro Technologies I feel myself more confident.There is lot of focus on the interview preparation also giving the students the real exposure of Interview

    Mr. Jogendra
    Software Testing Batch
  • Before Joining JMicro Technologies I always thought its very difficult to enter into the IT MNC's but after joining JMicro Technologies I realize its not that difficult if one gets proper training and guidance by Industry experts

    Ms. Daizy Teotia
    Software Testing Batch
  • JMicro Technologies provides a professional environment of learning with lots of focus on practicle training along with strong theoritical base.The faculties are very cooperative and highly experts in their area. Its great to be a student of JMicro Technologies

    Mr. Vibhav
    Software Testing Batch