We are planning on using BODS to join BKPF(header) and BSEG(line item) tables in HANA and send the data across to SQL Server for reporting. We plan to use BODS Table Comparison transform with the ABAP Dataflow (RFC method) for delta management. The concern I have is that initially the HANA server will be a fresh installation and so limited number of records will be used in the Table Comparison transform. As time passes, the number of records in BSEG will grow and the Table Transform might become too resource intensive for the BODS server and network. Any expert advise on how to manage this scenario would be sincerely appreciated.
You should distinguish between source CDC and target CDC (Change Data Capture).
1/. Source CDC: Make sure you only select those records from the source tables that are new or have been modified since the last run. The logic for the BSEG table is in delta data loading for bseg table | SCN.
2/. Target CDC: in order to guarantee consistency at the target level, use a Table_Comparison transform. Performance implications can be found in .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.