New to this topic? Not sure where to start? For your convenience, we have created the below learning path where articles are organised in the order of their relevance and complexity. Start from the beginning and read one by one to master the subject.
|1||One Stop to SAP BODI/BODS||Basic|
|2||How to install SAP BODS - Standalone||Basic|
|3||SAP BODS Cluster Installation||Basic|
|4||Why SAP Data Services||Basic|
|5||Getting Started SAP BODS||Basic|
|6||Fools Guide to BODS - Introductory Tutorial||Basic|
|7||Fools Guide to BODS - Repository Creation||Basic|
|8||Fools Guide to BODS - Registering Repository to CMC||Basic|
|9||Fools Guide to BODS - Designer||Basic|
|10||SAP BODS Transforms||Basic|
|11||Working with Data Services Flatfiles||Basic|
|12||How to handle multiple input file in SAP Data Services||Intermediate|
|13||Data Services Flatfiles Tips||Basic|
|14||XML file generation using SAP Data Services||Intermediate|
|15||Handling XML source files in SAP Data Services||Intermediate|
|16||Exception Handling While Reading Multiple XML Files in Data Services||Intermediate|
|17||Learning SAP Data Services - Online Tutorial||Basic|
|18||How to use Lookup and Join in SAP Data Services||Basic|
|19||How to use SAP Data Services Case Transform||Basic|
|20||Using MERGE Transform in SAP Data Services||Basic|
|21||Data Services Scenario Questions Part 1||Basic|
|22||Data Services Scenario Questions Part 2||Basic|
|23||Data Services Scenario Questions Part 3||Basic|
|24||Data Services Scenario Questions Part 4||Basic|
|25||Data Services Scenario Questions Part 5||Basic|
|26||Data Services Scenario Questions Part 6||Basic|
|27||Data Services Scenario Questions Part 7||Basic|
|28||How to use Data Services Pivot Transformation||Intermediate|
|29||How to use Data Services Reverse Pivot Transformation||Intermediate|
|30||Table Comparison Transform to Implement Slowly Change Dimension (SCD) in Data Service||Intermediate|
|31||How to implement SCD Type 2 using History Preserve Transform in Data Services||Intermediate|
|32||How to implement SCD Type 3 in Data Services||Intermediate|
|33||SAP Data Services Analytic Functions||Intermediate|
|34||RANK in Data Services||Intermediate|
|35||DENSE RANK in Data Services||Intermediate|
|36||GROUP RANK in Data Services||Intermediate|
|37||Data Services Scripting Language||Advanced|
|38||SAP Data Services Custom Function||Advanced|
|39||Auditing in SAP Data Services||Intermediate|
|40||Error Handling, Recoverability- SAP Data Services||Intermediate|
|41||Real Time Jobs in Data Services||Intermediate|
|42||Web Service Call in SAP Data Services||Intermediate|
|43||Text Data Processing using SAP Data Services||Advanced|
|44||Map_CDC_Operation in Data Services||Intermediate|
|45||SCD implementation from Source based CDC table||Intermediate|
|46||Data Services Metadata Query Part 1||Basic|
|47||Data Services Metadata Query Part 2||Basic|
|48||Data Services Metadata Query Part 3||Basic|
|49||Top 50 SAP Business Objects Data Services (BODS) Interview Questions with Answers||Basic|
Learn the answers of some critical questions commonly asked during SAP BO Data Services interview.
This article is a continuation of the previous topic related to Data Services Metadata Query. Let us explore more into the Data Services Repository Metadata.
Data Services provides full access to the repository metadata tables and views for metadata analysis. To access this metadata either we can use SQL SELECT statements or use the metadata reporting from Management Console.
Consider a scenario where we want to capture all or any changes in the source table to be maintained as history in our data warehouse dimension table. So if we consider day end batch load we will miss out any intermediate changes to the master data as the OLTP system doesn't maintains version. But what if we have already captured the changes via database CDC mechanism. Then based on the operation type and operation order of CDC based source table we can ascertain the corresponding operations to the dimension table. We can even avoid lookup to the target dimension table for SCD Type 2 implementation with optimum performance.
Map CDC Operation is used to support relational or mainframe changed-data capture (CDC). This transform reads the source DML changes i.e. INSERT/UPDATE/DELETE and reflects the same in the target system. So the transform maps all the source rows logged as insert to an insert, all updates to update and the deletes to delete in the target table.
This article deals with Text Data Processing using SAP Business Objects Data Services with the intension of Text Analytics. SAP BODS provides a single ETL platform for both Structured and Unstructured data as well as Data Quality, Data Profiling and Data Cleansing functionalities.Entity Extraction transform available as a part of Text Data Processing of Data Services, helps to extract entities, entity relationships and facts from unstructured data for downstream analytics. The transform performs linguistic processing on content by using semantic and syntactic knowledge of words, to identify paragraphs, sentences, clauses, entities and facts from textual information.
SAP Data Services provides Realtime Data Integration features. Data Services can generate realtime event messages and can also listen to input XML messages. Real Time Job means, some message with content will trigger the Job or Dataflow processing. A RealTime Job is started once and keeps running basically for ever. So Data Services acts like a server process.
Error Handling, Recoverability are the important aspects of any ETL tool. Some of the ETL tools have some sort of in-built error-handling and automatic recovery mechanisms in place.
A proper data reconciliation process must be in place in any data Extraction-Transformation-Load (ETL) process. A successful reconciliation process should only indicate whether or not the data is correct. But data reconciliation is not easy. Fortunately for us, Data Services (BODS) provides an in-built data reconciliation feature called Auditing. Auditing is a way to ensure that a dataflow loads correct data into the target warehouse. Let's see how...
In this tutorial we will learn how to implement Cumulative Sum in SAP Data Services (BODS). Since there is no available in-built Analytic Functions in SAP Data Services, we will achieve the end result by exploiting some in-built Data Services features. Also this tutorial will show us how to manipulate Data Flow Parameter values at Data Flow level itself by using the trick of Custom Function calls.
In this tutorial we will learn how to implement Slowly Changing Dimension of Type 3 using SAP Data Services. SCD type 3 design is used to store partial history. Here we are only interested to maintain the "current value" and "previous value" of an attribute. That is, even though the value of that attribute may change numerous times, at any time we are only concerned about its current and previous values.
This tutorial teaches you how to use the "History Preserving Transform" in SAP Data Services (BODS) by demonstrating a practical use of this transform for the implementation of SCD Type 2. We have also provided hands-on video below so that you can see how to do it yourself.
In this tutorial we will learn a new SAP Data services transform, known as Table Comparison Transform and we will see how we may use this transform to implement "slowly changing dimension" (SCD) Type - I. Like before, we have added a video tutorial at the end to perform a little hands-on.