The ETL job could be designed to ch 1

[ProDev]

The ETL job could be designed to check for the existence of files, in case a file from Source system arrives, it’d be extracted by the ETL process and loaded into the staging area.

In above case, for the "the existence of files" what logic and where needed to be writen in informatica.

 

[srpvc]

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 this file and run your session with pmcmd command.
Hope you got clue
Venkat

 

[ProDev]

Hi Venkat,

Thanks a lot for your response.
It will be of a great help, if you can pls describe(steps involved) a bit more, in seting up the event "wait Task".

Also, can you pls let me know about a sample shell script /batch file and how do you call the same form informatica (with pmcmd command, as you mentioned).


Regards

[ Note:-I am new to Informatica, probabley will need this kind of spoon feeding ... ]

 

[srpvc]

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

 

[ProDev]

srpvc,

Iformatica version
I am on is, 6.2.

 

[srpvc]

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 copy into your specified folder.
as soon as it finds that file it starts executing next sessions
Hope this will help you
Regards
Venkat