Dataware house and information

Home / Dataware house and information

PREREQUISITE-

Databases Knowledge. Knowing SQL, Oracle or SQL server is a added advantage.

DETAIL COURSE CONTENT

Introduction to Data warehousin

  • Data Warehouse Architecture
  • DW design Methodologies: Bottom-up design, Top-down design (Inmon/ Kimball Approaches) and Hybrid Design.
  • Extract, transform, and load (ETL)
  • Database Design (OLAP- MOLAP, ROLAP & HOLAP)

Informatica 8.X

  • PowerCenter Architecture
  • Informatica Server, Repository and Client Installation & Configuration
  • Security, Server & Repository Management
  • Production Migration & Performance Tuning
  • Source Qualifier/ File Lists/ Workflow Scheduler/Reusable Transformations/ Debugger
  • Detailed Review of the Expression/ Filter/ Sorter/Aggregator/ Joiner/ Lookup/ Update Strategy/ Router/ Sequence Generator Transformations.
  • Source and Target Overrides/ Parameters and Variables/ Self-Join/ incremental Aggregation/ Dynamic Lookup Cache/ Mapplets/
  • Workflow Configuration and Techniques
  • Reusable Schedule for a Workflow/ Session Configuration/ Tasks and Worklets.
  • Performance tuning.
  • Creating and managing Repository
  • Designing the ETL (Extract, Transform & Load) Functions
  • Understanding The After-Design Scenario
  • Specifying the Database Connections

Revision and Class Performance Analysis

  • Case studies
  • Project Presentation by candidates
  • Domain Knowledge
  • Mock Interview practice
  • Resume preparation help

SCHEDULE

Weekday Training schedule: Monday to Friday 10:00AM CST – 3:30PM CST
Weekday Training Duration: 1 week

Weekend Training schedule: Saturday and Sunday 10:00AM CST – 3:30PM CST
Weekend Training Duration: 3 weeks

Total Hrs of Training: ~40hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

FEE DETAILS

Instructor led classroom training : $1600.00

Live online training : $800.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

REGISTRATION

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com . Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220 Robert Street S, #100
    Saint Paul,  MN-55107.

Live Online Training also available.

TRAINING FEATURES

  • Unlimited Training as many times as you want, till your confident enough to face interviews.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt
Show Buttons
Hide Buttons