7 Replies Latest reply on Aug 12, 2021 12:27 PM by user126898

    Scheduling in Informatica

    Retro Flame Guru

      Hi,

       

      Is it possible to schedule an import(Mapping task) for the first 7 days of every month in informatica cloud? I was not able to find a particular option for that in the scheduling option.

        • 1. Re: Scheduling in Informatica
          user126898 Guru

          Not within the built in scheduler.  You would have to use an external tool for that type of scheduling requirement or a script to call the task.

           

          Thanks,

          Scott

          • 2. Re: Scheduling in Informatica
            Retro Flame Guru

            hi scott,

            Thanks for your reply, How and where do we write a script and what type of script would be required for this task?

            Thanks again

            • 3. Re: Scheduling in Informatica
              user126898 Guru

              it could be a shell/bash script depending on your Secure agent server os.  That script can check the sysdate for what day of the month it is and from there kick off said mapping task.  You can kick it off via the runAJob CLI or an API call.

               

              You could also create a java or python script...it really is up to you on that front.

               

              Then you can schedule a taskflow to call said script that runs everyday and the script takes care of checking if the date is right and kicks off the mapping task to load data.

               

              Thanks,

              Scott

              • 4. Re: Scheduling in Informatica
                Nico Heinze Guru

                Hi Scott,

                 

                dumb question from an IICS-agnostic (myself): do task flows provide link conditions like in PowerCenter?

                In this case the solution depicted in some similar PowerCenter-related questions may come in handy here.

                This solution basically works as follows:

                A first mapping checks whether "today" is one of those days when the whole task flow is supposed to run.

                If so, the mapping produces one dummy output record.

                If not, the mapping does not produce any output.

                Now the link condition would pass control to the next mapping (the first "real" mapping) only if the first mapping succeeded and did produce some output (i.e. number of success target records > 0).

                 

                Does this work in IICS as well? This would enable the original poster to implement a solution without the need for any "external" scheduling mechanism.

                 

                Regards,

                Nico

                • 5. Re: Scheduling in Informatica
                  user126898 Guru

                  Nico,

                  good idea.  Yes this would work in IICS taskflows as well. 

                   

                  Shawn,

                  Based on what Nico mentioned here is what you could do with mappings and a taskflow.

                   

                  inside a taskflow

                   

                  mapping 1 check if the date is day 1-7.  If so output a dummy file, if not those dates end.

                   

                  decision task (simulates link conditions from PC).  If data task 1 outputted a success row it is day 1-7 proceed to mapping 2.  If success rows 0 then end workflow.

                   

                  mapping 2: data load.

                   

                  Thanks,

                  Scott

                  • 6. Re: Scheduling in Informatica
                    Nico Heinze Guru

                    Hi Scott,

                     

                    first thanks a ton for the info.

                    Second one follow-up: if I understand correctly, everything that can be done via workflow link conditions in PowerCenter can be done in IICS using Decision tasks?

                     

                    Thanks and regards,

                    Nico

                    • 7. Re: Scheduling in Informatica
                      user126898 Guru

                      That's correct Nico

                      1 of 1 people found this helpful