Skip to Content
avatar image
Former Member

Getting My Feet Wet...Using SLT To Insert Batches of Delta Rows into Hana

Hello folks. I am getting myself familiar with SLT. I basically have a requirement to use SLT to insert delta rows from an SAP ERP systems into downstream Hana Database staging tables that support customer proprietary analytic applictions.

We want to achieve the following functionality:

  • Audit deltas from source to target system
  • Transaction Consistency
  • Apply business logic
  • Atomic Invocation
    • Achieve all above ideally in same call stack, without supplementary processes (other than Hana of course)

One approach under consideration is using a trigger in the staging table. If the trigger discovers that the row is the last row of a batch, it would call a stored procedure to do all of the above. Of course, I'd like to understand if SLT supports the ability to facilitate, accentuate, or achieve this kind of functionality, beyond just replicating rows.

For example, could SLT be used to append a dummy row to each replicate of rows? Can SLT call a stored procedure after inserting a replicate of rows?

I apologize in advance for my naive here...and thanks in advance for any insight.

Cheers, Mate Radalj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 06, 2014 at 02:38 PM
    Add comment
    10|10000 characters needed characters exceeded