top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Informatica: Text file location and its data check on FTP server

+2 votes
300 views

How to check using informatica whether a flat file exists at a location at FTP server also to check if it contains some data?

posted May 27, 2014 by Madhavi Kumari

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

One solution is to create Windows or Unix shell script on the Informatica server that checks for the existence of the file. Something like this:

#!/usr/bin/ksh

if [ ! -f /Filelocation/INPUT_FILENAME.txt]
  then
    echo "Source not found"  
    exit 1
  else
       echo "Source present"     
          exit 0
  fi
done
exit 1

Create a command session in Workflow that runs this script.

answer May 28, 2014 by Shweta Singh
Similar Questions
+1 vote

How to check in informatica whether a flat file exists at a location at FTP server and to check if it has some data in it?

+2 votes

I wanted to develep the workflow which continuously running and looking for the file..

The source file data is like this :

eno
10    
20    
30    
40

Once the file received in the FTP location , the workflow should automatically pick the file and load into the target Table.

The output of target table table will be like below

eno    Received
---    -------
10      Y
20      Y
30      Y
40      Y
50
60
70
80

the condition to load the target table would be [ Update EMP_TGT set Received='Y' where eno=' ]

+2 votes

I have few file names and need to identify which mapping/workflow is generating those files?
Is it possible to check this in repository or at UNIX level.

+1 vote

I have to load the target table copy of data into the text file at the time of workflow running.(i.e)Whatever data are going into the the target table that should come into the text file also.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...