? 
Datawarehouse and Datastage V8 Training starting 24th April 2010.
Join Twin Cities Training Group on Linkedin.com to get latest updates on jobs and training.
Follow us on https://twitter.com/ITE_Training
About Institute Of Technical Education (ITE)
ITE is a leading provider of technical education & training for students seeking careers as I.T. professionals in the field of Business Analysis, Quality Assurance, ERP, Development, or Database Designing and Administration. The institute offers 3 months diploma and certificate programs at the campus in Bloomington, Minnesota. Visit www.instituteusa.com for more information.
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 – 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-340-0701 or email training@instituteusa.com to get a detailed course content.
Training Features
Weekday Morning and Weekend training sessions available.
New facility with labs and remote access 24/7.
Just tool access available for 3 months. Call on 651-340-0701 for more information.
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.
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 – 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.
Weekend Training schedule: Saturday and Sunday 10:00AM – 4:00PM
Weekend Training Duration: 3 weeks
Total Hrs of Training: 40hrs (excluding homework and assignments time)
NOTE: Take home Assignment & homework is worth extra 40hrs.
In class training locations available in Minneapolis and St Paul area.
Contact Details: Email us at training@instituteusa.com or call at 651-340-0701 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.