Search results for query: *

HI, You have to Pass SessionName & InstanceName & SessionStartDate as parameters to the small mapping which will lookup from rep_sess_log table and load into your table. This will helpful only if you have access to meta data else you could ask to grant access to these views Regards Venkat

for your second one You can sort based on col1 and use variable port which will contain incresed value by 1 if previous record and currect record is same. if previous record and currect record are different then reset this varianle to 1. even you need to have one more variable to track previous...

It Can be an idea rather than solution to your problem. Create one file tmp_To_Raise_Event.ind manually. In your first workflow at the end add one command task. give command as copy tmp_To_Raise_Event.ind workflow_finished.ind And in second workflow add Event Wait task with Predifined option...

WHile designing your workflow create EventWait Task before your session which uses those files. Go to events tab in EventWait task and select predefined and specify one of your filename. and make sure you have not set delete filewatch file option in properties tab. When ever files arrived.or...

Let me know which version you are using then i can tell you exact steps

I ProvDev, Which version of informatica you have been using??? if you are using informatica 6.1+ then you can use event wait Task. you can mension this file name in even wait as file watch. then you can run the sessions . other wise you need to write a shell or some script which will look for...