1 Reply Latest reply on Sep 13, 2013 11:01 AM by SriniVEERAVALLI

    Need an efficient solution using Informatica Power center

    138a3b4e-571c-4019-8744-22e47e4134a5


      Need an efficient solution using Informatica Power center-

       

      I have a requirement-

      1-I have a database which gets refreshed everyday.
      2-I have a workflow which gets started only if the database gets refreshed.

      So I have to design a workflow-- which will do the following things-
      a- Checks if the database has been refreshed today or not(Not hard coding...as this workflow will run everyday to check that)
      b- If the database has been refreshed then only start the workflow wf_XYZ
      ( SUGGESTION-may be after the session/task finds out that the db has been refreshed it can create a trigger file which will eventually start the next workflow) else can wait to get the db refreshed.