Join the Community

Sponsor

Free BI Digest

Need more help on this subject?

SAP BusinessObjects Data Services

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

SCD implementation from Source based CDC table

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.

Read more: SCD implementation from Source based CDC table

Map_CDC_Operation in Data Services

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.

Read more: Map_CDC_Operation in Data Services

Real Time Jobs in Data Services

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.

Read more: Real Time Jobs in Data Services

Fools Guide to BODS - Designer

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.

Read more: Fools Guide to BODS - Designer

DENSE RANK in Data Services

In this article, we will learn how to implement DENSE RANK operation in SAP Data Services.

Read more: DENSE RANK in Data Services

Fools Guide to BODS - Registering Repository to CMC

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.

Read more: Fools Guide to BODS - Registering Repository to CMC

GROUP RANK in Data Services

In this article, we will learn how to implement RANK and DENSE RANK operations on GROUP in SAP Data Services.

Read more: GROUP RANK in Data Services

Fools Guide to BODS - Repository Creation

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

Read more: Fools Guide to BODS - Repository Creation

RANK in Data Services

In this article, we will learn how to implement RANK operation in SAP Data Services.

Read more: RANK in Data Services

Fools Guide to BODS - Introductory Tutorial

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.

Read more: Fools Guide to BODS - Introductory Tutorial