I have a list of tables to be processed one after the other by one WF. firstly this workflow should detect how many tables should get processed by workflow on the base of table name prefix ,it should process tables which are having current date like ex tableone_sysdate, tabletwo_sysdate, tablethree_sysdate . so this workflow will run 3 times and process three tables one by one. I will use dynamic parameter file generation approach to process different tables with one workflow one by one.
Use concurrent workflow option to achive this task.For more details about this ,please refer the below thread.
The following example on Informatica Marketplace website should help you. You will also find over 100 mapping / workflow samples and many Informatica tools and utilities on the same website.