Data warehouse and Datastage V8 Training starting 31th July to 15 Aug 2010

Data warehouse and Datastage V8 Training starting 31th July to 15 Aug 2010

Call now on 651-222-9922 or email at training@instituteusa.com to register please do visit our website www.instituteusa.com for more information.

NEW! Free training, accommodation and placement, only for students with valid work authorization

NEW! Register for One Training and Get Training for Half Price, Only for limited time.
Call on 651-222-9922 & 651-340-0701


Benefits with American Institute of Technical Education (AITE)

• Job placement assistance and interview calls
• On-job technical support for 1 year
• 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.

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 analysis
• 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
• Total Hrs of Training: 40hrs (excluding homework and assignments time)

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


About AITE
American Institute of Technical Education (AITE) is a licensed as a private career school providing technical training for students seeking careers as Information Technology (IT)/Software professional as Business Analyst, Quality Analyst, ERP Specialist, Programmer or Database Designer and Administrator.
We offer 3-month diploma and certificate program at our campus in Bloomington, Minnesota.