Not easy to achieve.

With current technology, you should set up some shell script (resp. Windows batch file) which invokes one IICS job to initialise the loop somehow (e.g. by initialising a parameter file); then invokes the actual "load job"; checks whether the end condition for the loop has been reached; and - if not - repeats itself until this termination condition has been reached.

If you have access to PowerCenter, you could use the Loop Transformations which I have published back in 2016 (unfortunately I can't find them any longer on the Informatica Marketplace). These Loop Transformations (a Loop Begin transformation and a Loop End transformation) must be included in PowerCenter mapplets (each one in its own mapplet), then you should be able to import these mapplets into your IICS mapping and make use of them. But again. without PowerCenter (in order to create the mapplets) no chance to do that.

One additional word of warning: the Loop Transformations as published in 2016 work only on Windows, I haven't taken the time yet to adapt them for Linux. Not a big deal, I just haven't had the time yet to do it.

If anyone has a different suggestion, I would be happy to learn it.

Regards,

Nico

Try to explore CAI implementation with CDI.

Hi Srini,

could you please explain to non-IICS guys like me what these abbreviations mean?

Thanks,

Nico

Check this KB 478024

This might be possible with-in CDI after upcoming release in few days.