Skip to main content
Known Participant
Nov 21, 2023 8:11 AM UTC
Question

Convert MNI into batches/ Looping

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
    Known Participant
    Nov 21, 2023 9:00 AM UTC

    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
    Brainy
    Nov 21, 2023 9:30 AM UTC

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

    itsm6335Author
    Known Participant
    Nov 21, 2023 9:32 AM UTC

    Thanks