2 Hours/day – 1 Hour Theory, 1 Hour Practical
4 Hours/day – 2 Hours Theory, 2 hours Practical

Course Content:

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 3rd party system

Fill Form For Free Classes