| |
Data warehouse and Datastage V8 Training
Data warehouse and Datastage V8 Training
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-0701to get more details or visit www.instituteusa.com.
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
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 (ITE) 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.
|