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:
- Stage Source SAP ECC Data to Stage table on SQL, Say ST_BSEG_ORACLE. This has data for only one client.
- 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