-
1. Re: Looping a set of of transformations in Informatica cloud
Nico Heinze Nov 27, 2019 10:47 AM (in response to Ramta Batra)1 of 1 people found this helpfulNot 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
-
2. Re: Looping a set of of transformations in Informatica cloud
Srini Veeravalli Dec 2, 2019 7:19 AM (in response to Ramta Batra)Try to explore CAI implementation with CDI.
-
3. Re: Looping a set of of transformations in Informatica cloud
Nico Heinze Dec 2, 2019 9:49 AM (in response to Srini Veeravalli)Hi Srini,
could you please explain to non-IICS guys like me what these abbreviations mean?
Thanks,
Nico
-
4. Re: Looping a set of of transformations in Informatica cloud
Ramta Batra Dec 2, 2019 8:17 PM (in response to Srini Veeravalli)Hi Srini,
Could you please explain in detail, could not understand what you are trying to tell.
Thanks
-
5. Re: Looping a set of of transformations in Informatica cloud
Srini Veeravalli Dec 3, 2019 5:53 AM (in response to Ramta Batra)Check this KB 478024
This might be possible with-in CDI after upcoming release in few days.