Training-SAP-BODS

• Introduction to BODS
  • Introduction to Data Services – history
  • What is ETL and various ETL tools
  • Competitive advantage of BODS
  • Data Services components and architecture
• Data Services fundamentals
  • Data Services Architecture
  • Designer, Management Console, Repository, Job server
  • Concepts of Job, Workflow and Data Flow
  • Concepts of Datastore
  • Creating basic Batch Job
  • Transforms overview
• Database Connectivity
  • Data Store Fundamental
  • Types of Datastore – Database, SAP ECC etc
• Transformation Types
  • Query Transform
  • CASE Transform
  • MAP Transform
  • Working with hierarchical data
  • Hierarchy Flattening transform
  • Merging data
  • Table Comparison transform
  • Other ways of merging data for RDBMS datastores
  • Slowly changing dimension Types and SCD support in BODS
  • History preserving transform
  • Using built-in functions
• File processing
  • Defining file formats for file data source
  • Working with XML files(XSD,DTD)
  • File Formats as Source and as Targets
• Data Profiling
  • What is data profiling?
  • Column Analysis
  • Basic Profiling − Includes information like min, max, avg, etc.
  • Detailed Profiling − Includes information like distinct count, distinct percent, median, etc.
  • Relationship Analysis − Data anomalies between two columns for which you define a relationship.
• BODS Scripting Language
  • Variables in BODS – Scope of variable
  • Scripting language – Advantages and limitations
  • Custom functions in BODS
  • Creating simple function
  • Custom functions vs. database functions
• Error Handling in BODS
  • Validating Data Flow, Workflow, Job
  • Error handling on Workflow level – Try and Catch objects
  • Analyzing execution of Batch Job – Log files
  • Debugging in BODS
  • Handing execution errors – best practices
• Data Service Development
  • Local and Central repositories
  • Working in a group
  • Propagating Job from development to staging and production environment – best practices
  • Backing up metadata
  • ATL file. Export\Import operations
• SAP Information Steward
  • SAP Information Steward Overview & Highlights
  • Information Steward Architecture, Installation, and Deployment
  • Validation Rules (Create, bind, execute rules, view rule results)
  • DQ Scorecard (Create, bind, execute rules, view scorecard)
  • Creating Information Steward Views and Working with File Formats
  • Metadata management and Metapedia