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

7790

---

how rectifier transformer work in electroststic precipetatore(esp?

2095

---

What are three ways in which a thread can enter the waiting state?

558

---

What all data types can a set store? : salesforce crm

223

---

What does a pl/sql package consist of?

514

---

---

Is apple os more secure than windows?

430

---

How to generate random numbers with the rand() function in ms sql server?

564

---

is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?

587

---

discuss seperate determination concept

1579

---

what are the main important accounting entries for AP and AR ...

994

---

Explain the difference between mq version 6 and 7?

491

---

What is number in json?

1

---

Explain the use of tasktracker in the hadoop cluster?

372

---

How we can invoke child actions in ASP.Net MVC?

574

---

How to stop database server in postgresql?

476

---