Modules Covered in this Training

In this training, attendees learn:
Module 1. Data warehousing concepts
Module 2. Understanding Data Integrator
Module 3. Defining source and target metadata
Module 4. Validating, tracing, and debugging jobs
Module 5. Creating a batch job
Module 6. Using built-in transforms and nested data
Module 7. Using built-in functions
Module 8. Using Data Integrator Scripting Language and Variables
Module 9. Capturing Changes in Data
Module 10. Handling errors and auditing
Module 11. Supporting a multi-user environment
Module 12. Migrating Projects
Module 13. Using the Administrator
Module 14. Profiling Data
Module 15. Managing Metadata
Module 16. Data Quality Management

Attendees also learn:
1. Resume Preparation Guidelines and Tips
2. Mock Interviews and Interview Preparation Tips

Topics Covered
Data warehousing concepts
1. Describe dimensional modeling

Understanding Data Integrator
1. Describe components, management tools, and the development process
2. Explain object relationship

Defining source and target metadata
1. Create a database data store and import metadata
2. Create a new file format and handle errors in file formats

Validating, tracing, and debugging jobs
1. Use description and annotations
2. Validate and trace jobs
3. Use view data and the Interactive Debugger

Creating a batch job
1. Create a project, job, work flow, and data flow
2. Use the query transform in a data flow
3. Use template tables

Using built-in transforms and nested data
1. Use the case, merge, and validation transforms
2. Import metadata from XML documents
3. Use the XML pipeline in a data flow

Using built-in functions
1. Use date and time functions and the date generation transform to build a dimension table
2. Use the lookup functions to look up status in a table
3. Use match pattern functions to compare input strings to patterns
4. Use database type functions to return information on data sources

Using Data Integrator Scripting Language and Variables
1. Explain differences between global and local variables
2. Create global variables and custom functions
3. Use strings and variables in Data Integrator scripting language

Capturing Changes in Data
1. Use Change Data Capture (CDC) with time-stamped sources
2. Create an initial and delta load job
3. Use history preserving transform

Handling errors and auditing
1. Recover a failed job
2. Create a manual, recoverable work flow
3. Define Audi points, rules and actions on failures

Concepts of SAP BW 7.3 on HANA
1. BW 7.3 powered by SAP HANA
2. In-memory optimized Infocubes
3. In-memory optimized DSO’s
4. Migration concepts of BW 7.3 on traditional Database to BW 7.0 on SAP HANA
5. Migrating standard Infocubes to In memory optimized Infocubes using migration Tool
6. Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool
7. Customer Testimonials

Supporting a multi-user environment
1. Describe terminology and repository types in a multi-user environment
2. Create and activate the central repository
3. Work with objects in the central repository

Migrating Projects
1. Work with projects in the central repository
2. Implement and modify group permissions

Using the Administrator
1. Add a repository and user roles
2. Set the job status interval and log retention period
3. Execute, schedule, and monitor batch jobs
4. Understand architecture, load balance index, and job execution in server groups

Profiling Data
1. Set up the Data Profiler and users
2. Submit a profiling task
3. Monitor profiling tasks in the Administrator

Managing Metadata
1. Import and export metadata
2. Use Metadata Reports

Data Quality Management
1. Connecting to SAP Applications
2. ABAP data Flow processing Using Data services
3. IDoc interface connectivity Using Data services
4. SAP Application table source in real jobs using Data services
5. Executing Batch jobs that contain ABAP Data flows
6. Connecting to SAP Net weaver Business warehouse
7. Using Data services in SAP NW BW environments
8. Defining SAP Net Weaver BW Data stores Using Data services
9. Loading into SAP NW BW Using Data services