save "filename.prm"

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
8945 Views
CSC, I also Faced
E-Mail Answers

Answer Posted / devi

save "filename.prm"

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

966

Define joiner transformation?

989

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1048

r u done any partitions in ur project?

1753

If informatica has its scheduler why using third party scheduler?

1196

What are the types of schemas we have in data warehouse.

899

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2256

What do mean by local and global repository?

1153

What is the function of union transformation?

1067

What is joiner change?

1079

How to implement security measures using repository manager?

1084

Which transformation should we use to normalise the COBOL and relational sources?

1143

How many input parameters can exist in an unconnected lookup?

1493

Can we override a native sql query within informatica?

989

What is a passive transformation?

1039