Save PARAMETER file with .prm extension.

CANNOT USE PARAMETER FILE!

Hi all,

I am trying to use parameter file for my workflow. This
could help me to filter records

where CITY = 'Portland'

Following is what I have done:

**in Designer
- create new parameter :
$$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial
value = [empty]
- Source Qualifier/ Properties/Source Filter:
CUSTOMERS.CITY='$$PARA_FIL'

**Create Parameter file: C:\Informatica\PowerCenter8.6.0

\server\infa_shared\BWParam\DynamicParamTest.txt
$$PARA_FIL='Portland'

**Configure workflow to use the parameter file:
Edit Workflow/Properties/Parameter Filename:
C:\Informatica\PowerCenter8.6.0

\server\infa_shared\BWParam\DynamicParamTest.txt

I also configured directory of parameter file for session
task.

However, I just got this in the session log:

[SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID
FROM CUSTOMERS WHERE

CUSTOMERS.CITY='$$PARA_FIL']

No record has been loaded to target. It seems that the
parameter file has not been read. I cannot understand the
reason why.

Could any of you kindly suggest me anything? Thanks

Question Posted / devi

4 Answers
9121 Views
CSC, I also Faced
E-Mail Answers

Answer Posted / devi

Save PARAMETER file with .prm extension.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is informatica worklet?

1063

difference between informatica 8.1.1 and 8.6

3677

How to load the data from people soft hrm to people soft erm using informatica?

1010

What is Cognos script editor?

4227

How can we update a record in the target table without using update strategy?

1144

What is the command used to run a batch?

1062

How to convert multiple rows to single row (multiple columns) in informatica

1378

How can we delete duplicate rows from flat files?

1223

Explain the tuning lookup transformation - informatica

988

Explain dynamic target flat file name generation in informatica

1048

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2062

How to update source definition?

1082

How to do unit testing in informatica? How to load data in informatica ?

1120

What is a standalone command task?

1204

What is standalone command task?

1314