CÔNG TY TNHH TRAINOCATE VIỆT NAM
ATC-SBO - SAP Business Objects

ATC-SBO - SAP Business Objects

Overview

Duration: 5.0 days

SAP BODS is a data processing platform, it is used in extracting data from all types of dissimilar systems, transform it into meaningful information and load it into diverse types of systems. With full visibility into data quality, business users of an organization can observe that how their data measures up against information governance rules and standards. Understand the working and importance of SAP BODS to deliver better solutions during crisis. Our training comprises of Basic data profiling and Query Transform, Platform Transforms Overview, Data Integrator Transforms and many more.

Objectives

  • Gain the knowledge to participate in implementing, administering, and managing data integration projects  
  • Acquire the basis for more advanced training in Data Quality Services 
  • Gain the ability to troubleshoot batch jobs and set up error handlings 
  • Attain potential to create batch jobs for the data integration

Content

Unit 1: BODS overview
1. Overview of the Data services
2. Data services benefits, associated products, interfaces
3. Data services Architecture on single and distributed environment

Unit 2: BODS Designer concepts
1. Creating the repository (Local, Central repository
2. Exploring the menu options in the designer
3. Creating the project, Job flow, Data flow, Work flows etc., defining different types of Data stores (Source and destination data stores)
4. Use data store and system configurations
5. Defining file formats for flat, Excel, XML files

Unit 3: Batch Jobs
1. Creating Batch Jobs
2. Work with objects
3. Create a data flow
4. Adding the Query transform to the data flow
5. Use target tables
6. Execute the job

Unit 4: Defining Data Integrator Transforms
1. Date Generation Transform
2. Pivot Transform
3. Reverse Pivot Transform
4. XML_Pipeline Transform

Unit 5: Defining Data Platform Transforms
1. Query Transform
2. Case Transform
3. Merge Transform
4. Validation Transform
5. Row Generation Transform
6. SQL Transform

Unit 6: Defining Data Quality Transform
1. Address Cleanse
2. Geocoder

Unit 7: Implementation of SCD
1. SCD Type0

  • Query Transform


2. SCD Type1 o

  • Table Comparison Transform
  • Map_Operation Transform

3. SCD Type2

  • Table Comparison Transform
  • History Preserving Transform
  • Key Generation Transform


Unit 8: Using Functions, Scripts, and Variables
1. Define built-in functions
2. Use functions in expressions
3. Use variables and parameters
4. Create Custom functions
5. Use Data Services scripting language

Unit 9: Data assessment
1. Using the data profiler
2. Using the validation transform

Unit 10: Setting up Error Handling
1. Set up recoverable workflows

Unit 11: Setting up Exception Handling
1. Try/Catch Techniques

Unit 12: IF Conditional

Unit 13: While-Loop Implementation

Unit 14: Capturing Changes in Data

Unit 15: Data assessment
1. Update data over time
2. Use source-based CDC
3. Use target-based CDC

  • SCD Type 2


Unit 16: Multi-User Environment (Local Repo Vs Central Repo)

Unit 17: SAP Integration
1. Data extraction from ECC system to File, Table and SAP BI
2. Data extraction from ECC Extractors
3. Data Extraction from SAP BW
4. ABAP Workflows

Unit 18: SAP HANA and SAP BODS Integration
1. Introduction to SAP HANA
2. Introduction to SAP HANA Studio
3. Create Data Store for SAP HANA
4. Perform the load into SAP HANA
5. Store the data in Column Store
6. Preview the data in SQL console of SAP HANA Studio

Unit 19: Information Steward
1. Data Insight
2. Metadata management
3. Metapedia

Audience

  • Project team members with basic knowledge of Data Integration and Data Warehousing concepts  
  • Project Managers and Data Warehousing Consultants who work with data integration

Prerequisites

  • Good knowledge in SQL and Data Warehousing concepts  
  • Proficient in basic Unix Commands

Certification

Trainocate Certificate of Attendance

Lịch khai giảng

Form đăng ký

Bằng cách nhấn nút "ĐĂNG KÝ", tôi hoàn toàn đồng ý với Chính sách bảo mật

Các khóa đào tạo Advanced Technology Courses khác

ATC-DSM - Professional Specialist Diploma in Search Marketing

The Professional Specialist Diploma in Search Marketing is an in-depth 30-hour course created and validated by the Digital Marketing Institute (DMI). In 2017, DMI was named by ValueColleges.com as among the top 30 best value digital marketing certification programs, the only non-traditional university in the list. The Professional Specialist Diploma in Search Marketing empowers and imparts you with the necessary skills to create, manage and implement advanced search marketing strategies using AdWords, PPC marketing, display marketing & remarketing techniques. The Diploma will provide you with the know-how to increase visibility of your brand and convert traffic from within search engines that is crucial to nearly every business operating today. This course is a 4 -day classroom training and at the end of the classroom training, a 3 hours certification exam may be taken. Becoming a Certified Search Marketing Professional will provide and equip you with the elements of search campaign planning, creation and measurement, along with an accredited certification to validate your new expertise. The Professional Specialist Diploma in Search Marketing Certificate is awarded to candidates passing the examination. The Professional Specialist Diploma in Search Marketing Certificate has been credit rated by Scottish Qualification Authority (SQA) at Level 8 on the Scottish Credit and Qualifications Framework (SCQF). SCQF level 8 corresponds to level 5 on the European Qualifications Framework (EQF).
4.0 ngày

Bản quyền thuộc về Trainocate Việt Nam

back to top