Empty File list

398 views
Skip to first unread message

Sats

unread,
Jun 21, 2011, 3:58:48 PM6/21/11
to denver-infor...@googlegroups.com
Hey Guys

I am using indirect Source filetype, and am generating a Filelist through a shell script.
If there are no files in the folder to be processed, the filelist created is empty.
But the informatica session fails with the following error:

Message: The indirect input file does not contain filenames.

Is there a way to not fail the session and proceed if the filelist is empty (assume there is no data to be processed?)

ty
Satish

Tom Nats

unread,
Jun 22, 2011, 8:33:59 AM6/22/11
to denver-infor...@googlegroups.com
I just did this. In the shell script, I create a file if there are no
files and a different file if there are some. (just stub files). In
the workflow, I have a decision based upon which file is there. If
nine, just end thenworkflow, if there is files, run the session. I'll
send screenshot later this morning.

Sats

unread,
Jun 22, 2011, 12:32:29 PM6/22/11
to denver-infor...@googlegroups.com
Thanks Tom. Nice idea. I implemented something exactly like that.

I put in the condition on the link that leads from the task that creates the filelist to the session that reads the file list. So if there were no records written to the filelist, the workflow doesnt proceed.

Sats
Reply all
Reply to author
Forward
0 new messages