Skip to Content
avatar image
Former Member

SAP SDI flow graph Batch Task-- Improve Performence

Hi,

We are trying de-normalize the data using SDI flow graph. We created a flow graph(Batch Task) which joins around 7 tables and inserts into a one flat table.

Flow graph is running perfect with out any issues, Further we want to know the bottle necks and improve the performance of the flow graph.

If there is any SQL/Stored procedure generated for the flow graph then where can i see the SQL/Stored Procedure (location path)?

We are on SAP HANA 1.0 SP12

Thanks

Srini

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 01, 2017 at 04:42 PM

    Hello Srini,

    the Flowgraph in Batch Task mode is generating a Taskplan which will then be executed.

    One way to look into the performance of those operators is to enable the "Just in time" preview on the last node of the flowgraph and activate the flowgraph again. You can now click on a small preview icon next to that node and you can then execute a select query on a generated calc scenario for the flowgraph including this operation. This Query can now be analyzed by right clicking on the query and analyze query.

    Kind regards,

    Timo Wagner

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03, 2017 at 02:42 AM

    Thanks Timo and Benedict for you valuable suggenstions.

    Thanks

    Srini

    Add comment
    10|10000 characters needed characters exceeded