Informatica

Description

INFORMATICA TRAINING (Duration: 45 Hours – 6 Weeks) – Authorised KRYTERION Partners for INFORMATICA CERTIFICATION

Money back Guarantee with 15% interest if not satisfied with quality of training

Request for a call
Make an inquiry

Fundamentals of ETL(Extraction Transformation and Loading) :

  1. Data Extraction
  2. Data Transformation
  3. Data Loading

Fundamentals of DWH (Dataware Housing):

  • What is Dataware housing
  • Difference between OLTP and OLAP
  • Difference between Normalized data and De-Normalized data
  • Difference between Star schema & Snow Flake Schema
  • Difference between Database , dataware house, Data mart
  • What is Source system , Staging Layer , DWH Layer/ Presentation Layer
  • What is Stage table, Dimension Table and Fact table
  • Benefits of maintaining Dataware house

Informatica Power Center :
Informatica Tools:

  • Designer
  • Workflow Manager
  • Monitor
  • Repository Manager
  • Informatica Repository Administration Console

Designer

  • Source Analyzer
    • Importing & creating various types of source definitions
    • Database (RDBMS), Flat Files, XML , MS-EXCEL etc
  • Target Designer
    • Importing & creating various types of target definitions
    • Database (RDBMS), Flat Files, XML etc
  • Fundamentals of Transformations
    • What is transformation
    • Difference between Active and Passive Transformations
    • Difference between Connected and Unconnected Transformations
    • Difference between Re-usable and Non-reusable Transformations
  • Transformations
    • Filter , Router , Sorter, Rank , UNION , Joiner , Expression , Aggregator, Source Qualifier, Normaliser, Sequence Generator, Lookup, Update Strategy, Stored Procedure
  • Transformation Developer : Creating Reusable Transformations
  • Mapplet Designer: Creating Mapplets
  • User Defined Functions (UDF)
  • Error Handling and Debugging
    • Stop on Errors
    • Override Tracing Levels
  • Incremental Aggregation
  • Concepts of Parameter file , Mapping Parameters & Variables
  • Concept of Parameters & Variables:
    • Mapping Parameters
    • Mapping Variables
    • Built-in Variables
    • Server Variables
    • Session Variables
    • Workflow Variables
  • Implementation of Delta/Incremental load using Mapping Variables
  • Concepts of Informatica Cache’s
    • Index Cache, Data Cache ,Static Cache ,Dynamic Cache & Persistent Cache
  • Maintaining Historical data in Dataware houses using Concepts of Slowly Changing Dimensions (SCD’s):
    • Type1
    • Type2
      • Using Effective Date Ranges
      • Using Flag/ Indicator Column
      • Using Versioning
    • Type3
    • Type6(1+2+3) Hybrid Approach
  • Configuring Lookup Transformation with Dynamic Cache

Workflow Manager

  • Basic Session Properties
  • Load types : Normal Vs Bulk
  • Target Properties:
  • Insert
  • Update
    • Update as Update ,Update as Insert ,Update else Insert
  • Delete
  • Truncate table
  • Treat Source Rows As Property
  • Difference between a task , Worklet and Workflow
  • Link Conditions
  • Different types of tasks:
    • Re-usable:
      • Session , Command , Email
    • Non-Reusable
      • Timer , Control ,Decision ,Assignment ,Event- raise ,Event-Wait
  • Scheduling a Workflow

Workflow Monitor:

  • Monitoring Sessions & Workflows
  • Read and Understand Workflow , Session Log files
  • Identify errors from Log files
  • Re-start , stop , Abort tasks & workflows
  • Advanced Concepts:
      • Overview of Performance Tuning & Tuning Guidelines
      • Basics of Pipeline Partitioning
      • Introduction to Push Down Optimization(PDO)
      • Overview of Informatica Power Center Architecture
      • Basics of Informatica Power Center Administration
        • Code import , Export & Deployment
        • User Management: Create Users , Groups , Roles
        • Creating Folders

    Miscellaneous Concepts:

    • Target Load Plan
    • Generate Execute
    • Shortcuts Vs Copies
    • Stop Vs Abort
    • Start Vs Cold Start
    • Overview of Load Manager(LM)
    • Overview of Data Transformation Manager(DTM)
    • Concepts of Overriding
    • Overview of ETL Designing
    • Overview of ETL Testing
  • A Small Case Study

About the Trainer:

  • Real Time working &Certified Professional
  • Has experience in delivering Corporate Trainings
  • Has overall experience of 10+ years in IT
  • 8 Years real time work experience in Informatica
  • Delivered projects / POCs onInformatica

Highlights of the Course:

  • Teaching is oriented towards –
    • Practical oriented & Hands on
    • clear understanding of basics
    • what to expect as an interview question while topic discussion
  • Exclusive Access to a variety of latest interview questions and answers
  • Work on real-time projects
  • Certification guidance & Material
  • Hand-outs will be given which would serve as a knowledge-check
  • Assistance in Resume preparation
  • Interviews guidance
  • Corporate level Training
  • Finally, this training gives you all that are needed to secure a desired job & keeps you get going in your job!

Why Gyanvriksh:

  • Authorized SERVICENOW Certification Partners
  • Money back guaranteewith 15% interest if not satisfied – Quality Assured
  • Rated 90% excellent by students – Refer JustDial & Facebook reviews & reviews
  • Complete Practical Oriented Hands on Training
  • Situated in IT Hub Kondapur/Madhapur – Main Road
  • Experienced, Certified & Real time working professional
  • Class recordings of every session will be provided – Only for Online Training
  • Maximum batch size 25 to give more focus at individual level. Online 1 to 1
  • Register for a course and attend same course of same faculty in future any number of times for free
  • Weekend, Weekday, Online & Corporate Trainings
  • Nice ambience & AC Classrooms