Skip to Content
avatar image
Former Member

Semi Join.

Hi Experts.

good  evening everybody.

Could you please let me know what are properties and where  we need to enable for semi join .

Best Regards,

Reddeppa K.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 26, 2015 at 11:49 AM

    Hi,

    You can update the semi join parameters in Data Federation Admin tool.

    Under the system Parameters tab->SEMI_JOIN_EXECUTION_STRATEGIES

    #BI4 Performance Optimization for Multi-Source Universes & #SAPBW Jco Queries -- Part 1

    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Sonet Kebede

      Hi Kebede,

      I didn't find any Filtered Columns in details panel. i only found Schema, Keys ,Statistics, capabilities. Data Federation SQL and Native Connector Query .

      Following Parameters i set.:

      System Parameters:

      Updated statistics.

      SEMI_JOIN_DIMENSION_CACHE_MEMORY_SIZE=6114 (6*1024) (using 1 column only for join condition)

      MAX _CONCURRENT_MEMORY_CONSUMING_QUERIES=10

      MIN_ACTIVATION_THRESHOLD_FOR_ SEMI_JOIN_RULE=10000

      ACTIVATE_SEMI_JOIN_DIMENSION_RUNTIME_CARDINALITY_LIMIT = false

      EXECUTOR_TOTAL_MEMORY =80%


      Connector Configuration: (the database which one having more data)

      maxValueINInclause:50000

      Semijoinmaxqueries:10

      pls let me know still i need to set any other parameters

      Thanks.