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

7766

Which is better hashmap or hashtable?

466

what are micro-cap, small-cap, mid-cap, large-cap companies?

1770

How do I create an ftp?

616

Why is mercuric chloride added?

633

What is a marshmallow in android?

493

What is fram control?

465

What is a document in sap? : fi- general ledger

585

Explain when you can use unbinding function in backbone.js ?

5

What is available mechanism for connecting from applications, when we run hive as a server?

476

Explain beaconing?

210

Does a primary key have to be a number?

512

Have you ever tested 3 tier applications?

1529

Do search engines dislike frames?

512

How many types of v variables'? Where will appear for variables in odi?

268