Answer Posted /
| Is This Answer Correct ? | Yes | No |
Post New Answer View All Answers
company accounts introduction?
How do I create a formula for conditional formatting in excel?
How do I kill multiple processes in windows?
Explain sap netweaver gateway central hub deployment in sap fiori?
How can you separate hydrogen peroxide into hydrogen and oxygen?
How does a database partition work?
How do I insert multiple rows in a table?
What is the two level of data entry concept in recruitment?
What is InnoDB?
What happens with existing visualforce pages in lightning experience?
What is memristor? What is its advantage?
What is assisted conversion?
My load is 1635 KW. & current pf is 0.884, I have to improve it for 0.99.Please suggest what KVAR value is needed?
What javascript method would convert the string “20” to an integer (on the fly) so “20” + 20 = 40?
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