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
S
Subham Dixit
said
4 months ago
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
S
Subham Dixit
said
4 months ago
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.
Amanda Brine
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;
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.
Subham Dixit
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.
-
Import Data Into Entities via Azure Data Lake
-
Recover Deleted(soft Delete) Record and Configure in Application
-
Data Quality in batch mode and real-time integration
-
Integration with analytics tools
-
Query/Load/Delete data with the REST API
-
Does the Done Tab in Inbox have a limit?
-
How Can I Trigger Enricher or Sql Procedure when deleting?
-
Matching Rules But Only The Latest Record Creates a Golden Record
-
Unstructured and Semi Structured Data in Semarchy?
-
Read CSV files from AWS S3
See all 73 topics