top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

informcatica workflow polling for a file under FTP location

+2 votes
630 views

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=' ]

posted Nov 17, 2014 by Ronu

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+2 votes

File watcher is small program that you can write using shell script or thru informatica event wait task that would poll on a file directory for a specific file. If the file is available Informatica will pick the file and load the data.

answer Nov 18, 2014 by Shweta Singh
Hi Swetha, thanks for your reply.
The source file format wll be ack_file1 , ack_file2, ack_file3...

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

the file should move to archive path. If the FTP path has more than one file, it should pick the files one by one...

How to acheive this?
I would suggest you just look into the manual of ftp command line ftp-tool and script with that.
 
Alternative: use wget to download the ftp-file to local machine, then scp to target machine, I suppose using public-key-authentication for ssh, that scp does not need a password, then it should end up simple like this.
 
wget --ftp-user=$USERNAME --ftp-password=$PASSWORD ftp://$HOSTNAME/ABC/$Y.tar
 scp $Y.tar $SCPUSER@$SCPHOST/targetpath/$X.tar
0 votes
answer Nov 21, 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

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

0 votes

In a mapping we use delimited flat file having 3 columns.The column separated through comma. But i have a requirement that in between the column there is a column having 2 comma.So how should I process the column in the mapping?

+4 votes

I have a scenario where my source file name will be coming from one db table I have to read that value and pass it in the value of Source File Name in Session properties.

Till now I have tried like I have created 2 sessions where the 1st session will read the db table where the source file name is stored and store it in one mapping variable and in post success variable assignment

I am assigning the mapping variable value to workflow variable and in the next main session I am trying to give the workflow variable in the session file name attribute .

But it is showing error like below

fail to expand variables in file field [$$WL_File].

How can I achieve this.

Please suggest some ideas.

+2 votes

I have a job scheduled by tivoli for an Informatica workflow. I have checked property to save workflow logs for 5 runs.

Job is running fine through informatica but if u try to run is from tivoli using pmcmd it fails to rename the workflow log file .

Please help, I am getting this error :

Cannot rename workflow log file [E:\Informatica\etl_d\WorkflowLogs\wf_T.log.bin] to [E:\Informatica\etl_d\WorkflowLogs\wf_T.log.4.bin]. Please check the Integration Service log for more information. Disconnecting from Integration Service

...