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
9134 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 are the conditions needed to improve the performance of informatica aggregator transformation?

1093

How to do the error handling of if ur source is flatfiles?

1968

how to load rows into fact table in data warehouse

1190

what is INFORMATICA TESTING process

2290

Explain sessions?

1064

Which files are created during the session rums by informatics server?

1180

How do you manage the Parameter files while migrating your data from one environment to another environment?

1018

What are the differences between a connected lookup and unconnected lookup?

1070

What is the commit type if you have a transaction control transformation in the mapping?

1030

Explain the types of transformations?

1068

What is the advantage of informatica?

1069

Where do we use mapping variables in informatica?

1065

How can you generate reports in informatica?

1029

How do you load alternate records into different tables through mapping flow?

1869

What is meant by pre and post session shell command?

1159