Dataware housing concepts

• Describe dimensional modeling

Understanding Data Integrator

• Describe components, management tools, and the development process
• Explain object relationship

Defining source and target metadata

• Create a database data store and import metadata
• Create a new file format and handle errors in file formats

Validating, tracing, and debugging jobs  

• Use description and annotations
• Validate and trace jobs
• Use view data and the Interactive Debugger

Creating a batch job

• Create a project, job, work flow, and data flow
• Use the query transform in a data flow
• Use template tables

Using built-in transforms and nested data

• Use the case, merge, and validation transforms
• Use the Pivot, reverse Pivot
• Hierarchy flattening

Using built-in functions

• Use date and time functions and the date generation transform to build a dimension table
• Use the lookup functions to look up status in a table
• Use match pattern functions to compare input strings to patterns
• Use database type functions to return information on data sources

Using Data Integrator Scripting Language and Variables

• Explain differences between global and local variables
• Create global variables and custom functions
• Use strings and variables in Data Integrator scripting language

Capturing Changes in Data

• Use Change Data Capture (CDC) with time-stamped sources
• Create an initial and delta load job
• Use history preserving transform

Handling errors and auditing

• Recover a failed job
• Create a manual, recoverable work flow
• Define audit points, rules and actions on failures

Supporting a multi-user environment

• Describe terminology and respository types in a multi-user environment
• Create and activate the central repository

Migrating Projects

• Work with projects in the central repository
• Creation of Profile Repository
• Understand Profiling

Using the Administrator

• Add a repository and user roles
• Set the job status interval and log retention period
• Execute, schedule, and monitor batch jobs

Profiling Data

• Set up the Data Profiler and users
• Submit a profiling task
• Monitor profiling tasks in the Administrator

Managing Metadata

• Import and export metadata
• Use Metadata Reports

Data Quality Management

SAP Integration

• Data extraction from ECC system to File, Table and SAP BI
• ABAP WorkFlows
• Extracting data from SAP BI using Openhub Services and Data services as 3^rd party system