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

9132

How much should I charge for a wordpress website?

166

How can you find out how many users are currently logged into the database?

606

How do we calculate GNP and GDP?

1295

How do I make a bootable usb drive?

1046

why require the ph, buffer during hplc mobile phase?

861

What is meant by metadata in context of a data warehouse and how it is important?

1204

Why is label used in html?

809

Name any two western Mathematician.

1138

Please explain what is deep learning?

1

What does it mean to associate a file?

950

When we use a context? : sap bobi

863

What is class invariant in c++?

1235

Which are the storage engines used by mongodb?

1

What are date and time data types?

999