Training
Provided by IT Updates Inc
DW,
Informatica,
Datastage Training
New training batch starting from
8th August,
22nd August,
5th Sept 09
Now
Available in a new facility with lab, remote access 24/ 7, day/ evening sessions, classroom/ live online training available. NEW!
Topics
Covered in
Data warehouse and Informatica 8. x
Datawarehousing
Datawarehouse lifecycle
Data Warehouse Architecture, 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 Tool
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
Topics Covered in Data warehouse and Datastage V8
Datawarehousing
Datawarehouse lifecycle
Data Warehouse Architecture, Methodologies: Bottom-up design, Top-down design (Inmon/ Kimball Approaches) and Hybrid Design.
Extract, transform, and load (ETL)
Database Design (OLAP- MOLAP, ROLAP & HOLAP)
Datastage V8 Tool
Introduction to Datastage a Deployment, Administration console, Designer, Director, Administrator
Combine data using lookup, join, and merge stages
Create jobs that read from and write to sequential files
Make jobs that read from and write to a relational database using the connector stages
Build jobs that process data using transformations, combinations, filterings, sortings and aggregations
Conduct searches and impact analyses
Produce job reports
Construct DataStage users
Administer the DataStage environment
Reusable Schedule for a Workflow/ Session Configuration/ Tasks and Worklets.
Performance tuning.
Creating and managing Repository
Designing the ETL (Extract, Transform & Load) Functions
Call on 651-222-9922 or email seema@itupdates. com to get a detailed course content.
Training Features
Free career counseling based on your education and industry experience.
Instructor led Training.
Lab exercises for each session.
Training available in live online or classroom training.
Day and evening training sessions available. a New!
New facility with labs and remote access 24/ 7- New!
Instructor support provided after training.
Training material constantly updated to remain competitive
Unlimited Training as many times as you want, till your confident enough to face interviews.
On Job and interview support.
Case Studies of our clients in various popular domain a 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.
Complete refund of training fee 2 months after the candidates secures a project while working with us.
Total training hrs 40. 00Hrs
Weekday, weekend and combination of both classes are available.
In class training locations available in Minneapolis and St Paul area.
Contact Details: Email Seema at seema@itupdates. com or call at 651-222-9922 for further info. Please put your contact detail, location and Training Options (Class room or online) in the mail along with best time to call.
a Make you COMPETITIVE.
| This is primarily ilt training |  | |  | |  | This is a workshop seminar |  | This may be appropriate for train the trainer situations |  | This is an online eLearning or CBT training program |  | This is an online tutorial |  | This is a self-directed course |  | This course may be available for home-study |  | Computer Lab Work |  | This class may involve group study |  | This program may be available on CD |  | This video may be available on DVD |  | Courseware may be available for purchase |  | This class may be available at a classroom in Bloomington, MN,
|
 | Contact IT Updates Inc for more information |
|
| Course Level: | basic through advanced | | Duration: | 40 hours | | Training Presented in: | English |
|
