
This lecture covers all the topics in brief that are covered throughout the course
This tutorial explains how to connect Flat files with Data Services
This tutorial explains how to process multiple files present on shared directory in single job
This tutorial explains how to handle issues when source structure is improper.
This tutorial explains how to create file format as Target
This tutorial explains how to work with Excel Workbooks
This tutorial explains how to work with XML files
This video explains how case transform works in BODS
This tutorial explains Preserve Expression order concept of Case Transform
This tutorial explains concept of Merge Transform
This tutorial explains concept of Validation Transform
This tutorial explains concept of Pivot Transform
This tutorial explains concept of Reverse Pivot Transform
This tutorial explains concept of Row Generation Transform
This tutorial explains concept of Date Generation Transform
This tutorial explains concept of SQL Transform
This tutorial explains basics of Table Comparison Transform
This tutorial explains compare columns in Table Compare Transform
This tutorial explains how table comparison transform deals with duplicate values present in source.
This tutorial explains the purpose of Key Generation Transform in BODS
This tutorial explains how duplicate values in target system is handled by Table Comparison Transform
This tutorial explains the purpose of History Preserving Transform. This tutorial is complete solution of implementing SCD Type-2
This tutorial explains how using Map Operation Transform source data can be manipulated
This tutorial explains the concept of joins in BODS
This tutorial explains the concept of lookup function in BODS
This tutorial explains the concept of lookup_seq function in BODS
This tutorial explains the concept of lookup_ext function in BODS
This tutorial explains the concept of variables and Scripting
This tutorial explains the how to use sql function in BODS
This tutorial explains the concept of Aggregate Functions in BODS
This tutorial explains the concept of Custom Functions in BODS
This tutorial explains how you can use ifelse concept using script and Conditional block
This tutorial explains how you can use loops in script and while loop block in BODS
This tutorial explains the use of Substitution Parameters in BODS
This tutorial explains System Configuration in BODS
This tutorial explains the Auto Correct load option in Target table
This tutorial explains the Overflow file option in Target table
This tutorial explains the ways of importing jobs to different environments
This tutorial explains the concept of Central Repository for migrating code to different environments
This tutorial gives an overview of Data Migration
This tutorial explains how to connect BODS with ECC and S/4 HANA systems
This tutorial explains Extraction and Staging of data
This tutorial explains transformation rules based on Mapping Sheet
This tutorial explains Preload report generation
This tutorial explains how to call BAPI in BODS and load data in SAP ECC system
This tutorial explains how to generate Reconciliation report
This tutorial explains how to call IDOCs in BODS
This tutorial explains how to load data in S/4 HANA system using IDOCs
This tutorial explains how to extract data from Amazon S3 services.
This tutorial explains how to load data to Amazon Storage Services S3.
This tutorial explains features of BODS Management Console.
This tutorial explains how to Try/Catch block for error handling in BODS
From Basic to Advance Learning!!
If you're looking to master SAP Data Services then you're at the right place. The course covers all major transformations in detail with all real time scenarios. You will learn how to load data in SAP S/4 HANA and ECC using BAPIs and IDOCs. Apart from understanding transforms and migration you will learn code migration methods.
Below points have been covered throughout the course:
· Extracting data from different sources like Flat File, Excel, XML.
· Transformations covered in the course includes: Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation, Date Generation, SQL, Table Comparison, Map Operation, History Preserving, Key generation.
· Explanation of SCD type1/2
· All types of lookup functions explain such as lookup_ext, lookup_seq, lookup
· Scripting
· Custom Functions
· If/else Conditional blocks
· Loops
· Substitution Parameters
· Variables such as local, global variables & parameters
· Auto Correct Load
· Overflow file functionality
· Exporting jobs to different environments
· Central Repository
· Data Migration Overview
· Mapping Sheet
· Connecting BODS with ECC & S/4 HANA
· Stages of Data Migration from SAP Data Services standpoint such as Extraction, transformation, validation, load using BAPI/IDOCs.
· Data Extraction from AWS S3 buckets.
· Load data to AWS S3 buckets.
· Understanding of Data Services Management Console
· Error handling using Try/Catch blocks.
The course also covers real time interview questions asked in the industry.