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

9131

---

How to get data between two dates with query in laravel?

712

---

hi to all,i done ccna,now im looking job,but it is very diffcult to get job in networking field,.........i dnt know what im doing wrongly,kindly help me and give the proper way...i have so much of interest in this field only

1906

---

Inside a php function, what param needs to be set in order to access a global variable?

972

---

How do I combine text and formulas in excel?

671

---

Classify Lathes.

1029

---

What is the relation between the concepts of chromatin and chromosome? Are euchromatin and heterochromatin part of chromosomes?

871

---

Is it ok for a woman to bleed after menopause?

716

---

What is finalize method in .net?

1124

---

What is approval process? Are automated actions supported by approval processes? How many?

431

---

printf(), scanf() these are a) library functions b) userdefined functions c) system functions d) they are not functions

1160

---

what are the considerations when picking a SAS/STAT procedure?

3374

---

What is $this in php?

979

---

Juxtapose the HTTP verbs GET and POST. What is HEAD?

3884

---

formula for convert liter in to pale

2269

---