Informatica - Data Warehousing Training

Training/Coaching/Tuition by Big Classes Hyderabad View Contact

Request Info

DataWareHousing Concepts

Introduction to Datawarehousing

• Data Warehousing concepts

• Dataware housing (What/Why/How)

• Data Modelling (Schemas, Facts and Dimensions)

• Slowly Changing Dimensions

• Metadata

PowerCenter Components and User Interface

• PowerCenter Architecture

• PowerCenter Client Tools

• Lab – Using the Designer and Workflow Manager

Source Qualifier

• Source Qualifier Transformation

• Lab Project Overview

• Lab A – Load Payment Staging Table

• Source Qualifier Joins

• Lab B – Load Product Staging Table

• Source Pipelines

• Lab C – Load Dealership and Promotions Staging Table and Real time issues

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

• 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 Data Staging Table and Real time issues

Debugger

• Debugging Mappings

• Lab – Using the Debugging

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

Usconnected 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 Transformations

• Active and Passive Transformations

• Data Concatenation

• Self-Join

• Lab-Reload the Employee Staging Table and Real time issues

SCD type1 – LAB

SCD type2 – LAB

SCD type3 – LAB

Mapplets

• Mapplets

• Lab-Load Product Daily Aggregate Table

• Review and more Lab Activities and Real time issues

• 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 Reusability

• 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

• Lab – Load Inventory Fact Table

Course Overview

Informatica online training is designed to explain that Informatica is a widely used ETL tool for extracting the source data and loading it into the target after applying the required transformation.
Informatica enables organizations to gain a competitive advantage in today’s global information economy by empowering companies with timely, relevant and trustworthy data for their top business imperatives.
Informatica course provides data integration software and services for businesses.
As an Informatica online training expert we offer a comprehensive portfolio of training on a variety of Informatica solutions.
With our expertise in the field of online IT training globally, we provide you Informatica training customized to your needs.

About Trainer

Trainer Information

A technology oriented professional Over 8 years of experience in DWH/BI domain across various projects Worked in different roles like Technical Lead, Team Leader, ETL Consultant and On-site Coordinator in various business verticals like Banking, Telecom, Sales and Insurance across India and Abroad.
Informatica Certified Professional
Involved in Design and Development of various Insurance, Banking, Telecom and Sales ETL/BI Applications
As a Trainer:

• 3+ years of experience in Professional trainings

• Completed 50+ online batches successfully

• Completed 20+ classroom batches successfully

• Handling corporate trainings.

Big Classes

BigClasses.com is been into the IT market since a decade. We have started our career 10 years back as a class room training provider. After 5 years in the classroom training, as a part of expansion in 2008, we have moved to online training. We are offering the services globally with local and international standards with real time exposure. Now, after 10 years of expertise in software training, we are one of the best online training service portals of the industry. This shows our standards and commitment towards the software learners.

Since inception of BigClasses.com, it has evolved into a cherished and most reliable retail and Corporate Training Company.

BigClasses.com Training is one training institute where online interactive training is a common experience and many students in the past have learnt, mastered, got certified and landed excellent jobs on their way to their careers. Our training takes place with well-prepared training materials. We provide documentation and the best interview preparation materials for learners.

BigClasses.com has access to a faculty of esteemed and highly qualified consultants to deliver the courses. These instructors are not in any way academics, but rather specialists actively involved in consulting to business in their particular fields. This gives the learners a fuller insight of the needs and as well as knowledge about actual and future trends in the market, and makes the courses extremely practical and relevant.

We don’t just give training and leave you on your own but support you even after you get into the job. We are providing web based online training in major IT Courses, where you can sit at home in front of the system and learn without travel or relocate during the training program. You can practice exercises and real-time projects which are given by our esteemed instructors.

Training is conducted by experienced and certified Instructors. Prestigious clients are included in our Clientele list and 100% Successful placement for excellent candidates.

BigClasses.com Institute is an online provider of IT technologies training products for individual and for corporate groups our training manuals and programs are designed to be used in a self-study or home based training environment. This allows any student the ability to learn at their own pace and on their own schedule.

Self-paced training is a very effective method of training and can be used with any schedule and with no previous experience. Effective results can be achieved in as little as 15 minute blocks of time not hours or days as is common with seminars and schedule courses.

All our materials are available with instant download which means you can get started on your training within minutes. The result is that you can show noticeable improvement in less than a day with our training Bigclasses.com.

Our materials are designed to be used in a self-study or home based environment so anyone can fit this training into any schedule no matter how busy it may be. Self-study also allows an individual the ability to train at their own pace and not have to worry about missing any concepts or being forced to proceed too slow like what might happen in a class or schedule group class.

We are dedicated to providing the very best in Bigclasses.com training while providing quality training at affordable prices. Our goal is to product training that is within the budget of anyone who desires to improve their IT skills.

Corporate Group Training: For companies or large groups who wish to provide quality Customer Service training for their employees, Bigclasses.com online training Institute is proud to announce their Corporate! Under our Corporate Training Program, we offer our Training package at group rates. This course encompassing 6 training modules covering both basic fundamentals and advanced techniques.

Bigclasses.com Training Certificate Program: A complete course in Bigclasses.com Training from Basic fundamentals through advanced skills, this complete course offers a single source for all your requirements and needs. Each module is designed as either a stand lone module or as part of a complete series so the student can target their most pressing needs first for maximum benefit. Upon successful completion of the program and the passing of a short test, a full color Certificate of Completion will be issued to the student.