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,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

---

What are the informatica performance improvement tips

0 Answers   Informatica,

---

How big was your fact table

0 Answers  

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

Define informatica repository?

2 Answers   Wipro,

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

---

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

---