1-678-619-2366

 

ONLINE TRAINING

 

Khamur IT Online Trainings with an excellent and real time faculty/trainer. Our Online training course content designed as per the current IT industry requirement. Informatica is having very good demand in the market, huge number of job openings are there in the IT world. Based on this demand 123 Trainings started providing Informatica Online Training. We provide regular and weekend classes as well as Normal track/Fast track based on the learners requirement and availability. Learners can attend the online classes as per their convenient  timings. As all our faculty is real time professional they will cover all the real time scenarios. We have trained many people on Informatica, We provide Informatica corporate trainings throughout the world we have more then 200 clients throughout the world. enroll the online training course with us and make yourself professional. We will give you 100% satisfaction guarantee, After completion of Online Training we provide 24/7 365 days technical support for required candidates as we have many Technical experts even we handle the projects from offshore, we reach the expectations even more then client expectation.  Only 123 trainings is the best institute in Hyderabad, India for Informatica Online Training  learners

INFORMATICA ONLINE TRAINING COURSE CONTENT

Data Warehousing Concepts

    Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing)
    Slowly Changing Dimensions (SCD1, SCD2, SCD3)
    Metadata
    Dimentinal Table
    Types Of Dim Tables
    Fact Table
    Types of Fact Tables
    OLTP (OnLine Transaction Processing)
    OLAP (Online Analysis And Processing)
    OLTP Vs OLAP
    Advantages of OLAP
    Different Methodologies of DWH
PowerCenter Components and User Interface

    Informatica PowerCenter Architecture
    Informatica PowerCenter Client Tools
    Start Using of the Designer, Workflow Manager and Workflow Monitor

Source Qualifier

    Source Qualifier Transformation
    SQL override in source qualifier transformation
    Source qualifier transformation joins concept
    Source qualifier transformation on Relational Databases
    Source qualifier transformation on File systems
    Source qualifier transformation filter concepts
    Difference Between SQL Override, Other Options
    Source Qualifier Transformation Performance Tunning
    Pre SQL and Post in Source Qualifier Transformation

 Expression, Filter, File Lists and Workflow Scheduler

    Expression Editor
    Filter Transformation
    File Lists
    Workflow Scheduler
    Lab Load the Customer Staging Table and Real time issues

Joins, Features and Techniques I

    Joiner Transformation
    Shortcuts
    Lab A Load Sales Transaction Staging Table
    Lab B Features and Techniques I and Real time issues

Lookups and Reusable Transformations

    Lookup Transformation
    Reusable Transformations
    Lab A Load Employee Staging Table
    Lab B Load Date Staging Table and Real time issues

Debugger

    Debugging Mappings
    Lab Using the Debugger

Sequence Generator

    Sequence Generator Transformation
    Lab Load Date Dimension Table and Real time issues

Lookup Caching, More Features and Techniques

    Lookup Caching
    Lab A Load Promotions Dimension Table
    Lab B Features and Techniques II
    Review and more Lab Activities and Real time issues

Router, update Strategy and Overrides

    Router Transformation
    Update Strategy Transformation
    Expression Default Values
    Source Qualifier Override
    Target Override
    Session Task Mapping Overrides
    Lab Load Employee Dimension Table and Real time issues

Dynamic Lookup and Error Logging

    Dynamic Lookup
    Error Logging
    Lab Load Customer Dimension Table

Unconnected Lookup, Parameters and Variables

    Unconnected Lookup Transformation
    System Variables
    Mapping Parameters and Variables
    Lab Load Sales Fact Table

Sorter, Aggregator and Self-Join

    Sorter Transformation
    Aggregator Transformation
    Active and Passive Transformations
    Data Concatenation
    Self-Join
    Lab Reload the Employee Staging Table and Real time issues

SCD type1 Hands-On LAB

SCD type2 Hands-On LAB

SCD type3 Hands-On LAB

Mapplets

    Mapplets
    Lab Load Product Daily Aggregate Table
    Review and more Lab Activities and Real time issues

Workflow Variables and Tasks

    Link Conditions
    Workflow Variables
    Assignment Task
    Decision Task
    Email Task
    Lab Load Product Weekly Aggregate Table

More Tasks and Re-usability

    Event Raise Task
    Event Wait Task
    Command Task
    Reusable Tasks
    Reusable Session Task
    Reusable Session Configuration

Worklets and More Tasks

    Worklets
    Timer Task
    Control Task

 

Online Training Courses Online Training Courses

 1-678-619-2366
  support@khamuritsolutions.com