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
What is const pointer and const reference?
List some methods supported by $http service in angularjs?
What is transaction commit in hibernate?
suppose having unique and duplicate but I want to load unique record one table and duplicates one table?
What is a void in java?
how to mention last year profit of ay private limited company in current year balance sheet ?
Is negative mass antimatter?
Declare a new variable in php equal to the number 3;
What are the salient features of automation anywhere?
Does django use sql?
How Reflection is used and what it's significance ?
What is the difference between a podcast and a rss?
How do I find url?
For database testing in selenium webdriver what api is required?