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

4 Answers   CSC,

---

What is domain and gateway node?

0 Answers  

---

What does role playing dimension mean?

0 Answers  

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

How are indexes created after completing the load process?

0 Answers  

---

What is deployment group?

0 Answers  

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

What is source qualifier transformation in informatica?

0 Answers  

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

0 Answers  

---

explain different types of modeling.

2 Answers  

---