top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

File location identification in informatica

+2 votes
246 views

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.

posted Mar 7, 2014 by Rohini Agarwal

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

1 Answer

+2 votes

If you have access to the PowerCenter repository database, you can get information about file connections associated with sessions (e.g. source or target files) from the Metadata Exchange (MX) views:

REP_SESSION_FILES contains file connections associated with reusable sessions
enter image description here


REP_SESSION_INST_FILES contains file connection information for session instances associated with workflows
enter image description here

Source: PowerCenter 8.6.1. Repository Guide (login required)

answer Mar 7, 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?

+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 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 this informatica requirement where, i am getting some files say 1000 files, these files gets divided into multiple folders on unix server. i want to rename this file, let me give you an eg:

File name:input
abc1.txt
abc2.txt
abc3.txt

Now I want to change these file names by adding account_no,client_no,datestamp(all these values resides in one table). eg:
abc1_123_123_date.txt
abc2_456_321_date.txt
abc3_789_765_date.txt

This is just an eg: ..like this I ll be having say 10 listfiles and each listfile ll contain 100 files.Do i need to create 10 mappings for each listfile or is there any way that i can implement this in single mapping.

Please note:I cannot club all files in one folder and then change the file names and then again divide into original directories, as sometimes we get files in separated directories and we have to change there name and keep them in that particular folder only(for other business logic).

Kindly provide solution for this.

...