Start a new topic
Answered

Monitoring Integration Loads with SQL

I am doing ETL for multiple entities. Entity A needs to move from SA to GD before I can begin entity b. Can I use my batch ID that I get returned from the command
    vBatch_id := SEMARCHY_REPOSITORY.INTEGRATION_LOAD.SUBMIT_LOAD(vLoad_id, 'Step1_Load_Country', 'PA’);

To query the table SELECT STATUS FROM SEMARCHY_REPOSITORY.MTA_INTEG_BATCH WHERE BATCHID = vBatch_ID;


Best Answer

Hello Amanda,


Yes, you are correct, you can use the vBatch_id returned by the SUBMIT_LOAD  function to query the STATUS from the  MTA_INTEG_BATCH, it will give you the correct output as expected, let us know if you face any issues or query further.


Thank you and have a nice day.

1 Comment

Answer

Hello Amanda,


Yes, you are correct, you can use the vBatch_id returned by the SUBMIT_LOAD  function to query the STATUS from the  MTA_INTEG_BATCH, it will give you the correct output as expected, let us know if you face any issues or query further.


Thank you and have a nice day.

Login to post a comment