Skip to Content
0
Jul 31, 2016 at 05:48 PM

Table Comparison - BSEG

213 Views

Hi Experts,

Here is our current environment

Source:

SAP ECC on Oracle Database

Target:

SAP ECC on Hana Database

Staging:

SQL Server

We are to compare both the systems using SAP Data Service 4.2 and sync the data to SAP ECC on HANA Database.

Current Approach:

  1. Stage Source SAP ECC Data to Stage table on SQL, Say ST_BSEG_ORACLE. This has data for only one client.
  2. Stage Target HANA Data to Stage table in SQL, Say ST_BSEG_HANA. This has data for all the clients installed on the Hana System

As we are to do a comparison of both the tables:

  • For Insert Records: Do a left outer join of ST_BSEG_ORACLE to ST_BSEG_HANA on Key fields and filter for records where key fields has NULLs for right table in result set.
  • For Delete Records: Do a left ouuter join ST_BSEG_HANA to ST_BSEG_ORACLE on Key fields and filter for records where key fields has NULLs for right table in result set.
  • For Update Records: Using SQL transform and write a script to perform inner join of ST_BSEG_ORACLE to ST_BSEG_HANA on Key fields and check for any of the respective fields same from both tables are not same.

Please suggest what would be a better approach, as this is taking a long to execute. We had to drop the plan to use Table_Comparison transform as this is taking more time than the above.

Thanks

Santhosh