SAP BusinessObjects Data Services provides a single enterprise class solution for data integration, data quality, data profiling, and text analysis. Learn more about SAP BODS here
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.
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.
In our earlier article on Data Services we have learnt how to register the local repository with CMC. In this part of the article we will start using Data Services Designer.
In our earlier article, we have learnt how to create a repository in BODS. Once that part is done, The final process before launching the BODS application is registering the repository with CMC.
In the first chapter of this article we have learnt the very basic of BODS. In this part of the article we will begin with BODS Repository creation process
This article is a guide to the readers who are totally ignorant about the tool SAP Business Objects Data Services. It is presented in a very simple way so that readers would be familiar with common terms, terminologies and would be able to run simple programs.