Skip to main content
I
itsm6335
November 21, 2023
Question

Convert MNI into batches/ Looping

  • November 21, 2023
  • 3 replies
  • 0 views

Hi Team,

I have a requirement where I need to convert MNI into batches/looping, since its reaching threshold(MNI has limitation of 1000).

Can someone help how to convert .

Requirement: I am trying to write data to database via Stored Proc(Data is huge). In advance I don't know how many records am getting to write in database via integration. 

I cannot use Record, since its old Application(Business People are not in favor to convert to Record, since it has dependency on 100 objects.)

 

    3 replies

    boddupallib637791
    boddupallib637791
    November 21, 2023

    i think we can use gates (before & after) and a pointer to perform while loop check for terminating condition and send indexed data to Stored procedure inputs.
    click for reference

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 21, 2023

    When you run your MNI one at a time, enable this checkbox and you will not hit that limit.

      I
      itsm6335Author
      November 21, 2023

      Thanks 

      Terms & ConditionsAccessibility statement