Skip to Content

Information on SDI tasks sequence run

Dear Experts,

I am new to SDI, need some information on task run. Below are the details information which I require.

kindly help.

1) Can we run the SDI different task in one job (sequence , one by one).

2) SDI task can be run in control M tool.

3) target table row deletion before insertion( is it possible to check and delete the target table rows and insert the records).

what approach we have to use.

4) SSIS related package flows can we be possible in SDI?

Regards

Raju

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 13, 2020 at 12:13 PM

    Three questions are related to workflows: How to run a task externally and in the proper sequence.

    For that SDI itself does not have a UI but starting a task is a SQL command (see start task). Hence you can build a Hana stored procedure calling one task after the other or you use external tools like control M to execute the SQL commands.

    Regarding question #3, the table loader has a load type. Normally it is empty, meaning it should use whatever the source told, insert, update, delete, upsert, truncate, replace. But you can override that by setting the loader type to autocorrect load.

    But we should check your usecase. Maybe all you ask for is to truncate the entire table prior to loading it instead of testing on every single record...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.