Check existence of a file from a Transformer

ag_ram · Post by **ag_ram** » Wed Mar 21, 2007 8:46 am

Hey Folks

Is it possible to find if a file exists from a transformer stage ..can we have a constraint defined based on the existence and non existence of a file

DSguru2B · Post by **DSguru2B** » Wed Mar 21, 2007 9:01 am

Sure you can. You need to write a routine that checks for file existence and returns an appropriate return value which you can then check inside the transformer and proceed. I wrote a simple one months back. Search for it here.

ganesh123 · Post by **ganesh123** » Wed Mar 21, 2007 9:01 am

I guess its possible from TX but you can check the existence of input file by using before job subroutine "DSWaitForFile"

ag_ram · Post by **ag_ram** » Wed Mar 21, 2007 9:04 am

DSguru2B wrote:Sure you can. You need to write a routine that checks for file existence and returns an appropriate return value which you can then check inside the transformer and proceed. I wrote a simple one months back. Search for it here.

Any keywords that i have to look for search ..

DSguru2B · Post by **DSguru2B** » Wed Mar 21, 2007 9:12 am

I could'nt find mine, and dont have time to search for more, Ray has a similar routine to do the same. Click here.

chulett · Post by **chulett** » Wed Mar 21, 2007 9:19 am

You sure you want to do that in a transformer? Once for every row processed by the job?

Use the 'Initial Value' area of a Stage Variable to do that if you only need to check once, then leverage that variable in the constraint for the job run.