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
9119 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

tell me the rules and responsblites in our project(my project is development)

1932

What is flashback table ? Advance thanks

1930

What is a snowflake schema?

994

What is target designer and target load order?

1103

Which development components of informatica have the highest usage?

1037

Explain the different dimensions.

963

How to create Target definition for flat files?

1220

Can you use flat files in Mapplets.

2648

How will the document be delivered to me?

1085

Can we create multiple integration service on single repository?

1187

Difference between Target-based loading and constraint-based loading?

996

Briefly describe lookup transformation?

1046

difference between repository database and repository service?

1150

Differentiate between a repository server and a powerhouse?

1118

expain about the tune parameters?

2414