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.