Pune
    Posted: 1 month ago by
    Shortlist

    Data warehousing Informatica Training in Pune on Live Projec

    Course
    Others
    You are
    Offering Professional Course
    Locality
    Vishrantivadi
     
    Reply
     

    Description for "Data warehousing Informatica Training in Pune on Live Projec"

    Hi All,

    We are industry experts providing training for DATA WAREHOUSING, Informatica ,Unix ,Oracle(SQL/PL-SQL) with project.
    Faculty: Real-time, Experienced.
    Duration: 2 Months (64 hours) - Weekends
    Location: Vishrantwadi,Pune
    Eligibility: Any Enginneering graduate or experience professional can learn
    Contact details: Girish, 164,C-Wing,Shoppers Orbit,Vishrantwadi,Pune-15
    Contact No: 9011025200
    Main Feature: Till Time 95% students got job in big MNC’s.
    Timing: 9 am -1 pm. Batches will be on week-ends only.
    We will cover following topics::
     Oracle-SQL/PL-SQL
     Data warehouse Concepts
     Unix Basics
     Informatica----all concepts and scenarios will be covered practically.
     Informatica project
     Optional: ETL testing training
    Syllabus:
    1st week: SQL –all SQL queries including practical scenarios with interview questions on SQL.
    2nd week: Data warehousing concepts- with practical design approach.
    Installation of all software’s, Overview of Informatica architecture, server, client, domain and nodes with Sample Informatica mapping
    3rd week: Work Flow Manager, Monitor , Session, Repository, Integration service, Folder, Source Analyzer, Target Designer, Mapping, Mapplet, transformation developer, Active and Passive Transformations, Expression, Filter, router, sorter, sequence generator.
    4th week: Aggregator, Joiner, Rank, Lookup(Static,dynamic,persistent,non-persistent,connected,un
    connected), Stored procedure, java, normalizer, Transaction control
    5th week: SQL transformation, Update strategy, Workflow task: Session, command, email, event wait, event raise, timer, link, decision, control, assignment ,worklet
    6th week: SCD 1, SCD2, SCD3,CDC,Parameterization(mapping, session and workflow level),pmcmd command, Pushdown optimization, performance optimization, checksum number approach,MD5 implementation,, Live scenarios.
    7th week: Project
    8th week: Project, Basic UNIX, Interview Prep, Q&A, Resume preparation and mock interview practice
    >> for details information please call will send detail syllabus on your mail.

    Key Points::
    • Real time scenarios
    Practical Implementation of SCD1, SCD2, SCD3
    Implementation of CDC
    Other useful scenarios will be covered.
    • Exercises for each Transformation and will teach installation
    • Real-time Overview of Informatica code Delivery and deployment process.
    • Real time Questions and Answers.
    • Data ware housing Concepts.
    • Testing Approach (Unit Testing, Integration Testing).
    • Project will be covered (Which will give full real-time experience about end to end Informatica Project Implementation) .
    • All study material will be provided which includes step by step implementation.
    • Informatica Installation step by step implementation:

     

    Discover a world of academic excellence with Paraakhya Educa

    CAT Classes in Pune India

    Digital marketing Agency in Delhi

    Limited Offer Alert On NEBOSH IDIP INDIA