SAP Data Services Management Console | SAP BODS Training | SAP Data Services Certification | Uplatz
https://training.uplatz.com/course.ph... this video tutorial on SAP Data Services Course from Uplatz, students will learn SAP Data Services Management Console the remaining important content part of it.
SAP BODS (SAP BusinessObjects Data Services, now known as SAP Data Services) is an ETL tool and a data processing platform used for extracting data from all types of dissimilar systems, transforming it into meaningful information, and loading it into diverse types of systems. With full visibility into data quality, business users of an organization can see how their data measures up against information governance rules and standards.
In any enterprise data is one of the most valuable assets, but as the amount and variety of data keep exploding, it is difficult for IT to manage and for business users to comprehend this data. SAP resolved this issue by introducing BODS to enable companies to transform, access, cleanse, enrich, and deliver any kind of data from any source to any target at any frequency.
Through this SAP Data Services training, you will understand the working and importance of SAP BODS to deliver data streamlining and management. Our training will cover each topic of SAP BODS in great detail for e.g. Basic Data Profiling, Query Transform, Platform Transforms Overview, Data Integrator Transforms, and more.
Syllabus
Lesson 1: BODS overview
· Overview of SAP Data Services
· Data services benefits, associated products, interfaces
· Data services Architecture on a single and distributed environment
Lesson 2: BODS Designer concepts
· Creating the repository (Local, Central repository)
· Exploring the menu options in the Designer
· Creating the Project, Job flow, Data flow, Work flows etc.
· Defining different types of Data stores (Source and destination data stores)
· Use data store and system configurations
· Defining file formats for flat, Excel, XML files
Lesson 3: Batch Jobs
· Creating Batch Jobs
· Work with objects
· Create a data flow
· Adding the Query transform to the data flow
· Use target tables
· Execute the job
Lesson 4: Defining Data Integrator Transforms
· Date Generation Transform
· Pivot Transform
· Reverse Pivot Transform
· XML_Pipeline Transform
Lesson 5: Defining Data Platform Transforms
· Query Transform
· Case Transform
· Merge Transform
· Validation Transform
· Row Generation Transform
· SQL Transform
Lesson 6: Defining Data Quality Transform
· Address Cleanse
· Geocoder
Lesson 7: Implementation of SCD
· SCD Type0
a) Query Transform
· SCD Type1
a) Table Comparison Transform
b) Map_Operation Transform
· SCD Type2
a) Table Comparison Transform
b) History Preserving Transform
c) Key Generation Transform
Lesson 8: Using Functions, Scripts, and Variables
· Define built-in functions
· Use functions in expressions
· Use variables and parameters
· Create Custom functions
· Use Data Services scripting language
Lesson 9: Data assessment
· Using the data profiler
· Using the validation transform
Lesson 10: Setting up Error Handling
· Set up recoverable work flows
Lesson 11: Setting up Exception Handling
· Try/Catch Techniques
Lesson 12: IF Conditional
Lesson 13: While-Loop Implementation
Lesson 14: Capturing Changes in Data
Lesson 15: Data assessment
· Update data over time
· Use source-based CDC
· Use target-based CDC
a) SCD Type 2
#SAPBODS #DataServices#ETLProcess#DataIntegration#DataTransformation#DataQuality #SAPTraining#DataManagement#BusinessIntelligence#DataProfiling
---------------------------------------------------------------------------------------------------------------
Welcome to Uplatz!
Uplatz is a leading organization providing Management Consulting, IT Training, Virtual employees, and Analytics services.
Uplatz is well known for providing instructor-led training and video-based courses on SAP, Oracle, Salesforce, Cloud Computing, AWS, Microsoft Azure, Big Data, Machine Learning, Python, R, SQL, Google Cloud Platform, Microsoft, IBM, Cisco, Adobe Technologies, DevOps, Project Management, Digital Marketing.
For any questions, queries, or payment related issues, simply contact us at -
[email protected]
https://training.uplatz.com
-----------------------------------------------------------------------------------------------------------