Answer Posted /
Is This Answer Correct ? | Yes | No |
Post New Answer View All Answers
What is the history on the invention of paper?
What are the different types of Streams in node.js?
What are the different types of vpns?
What is the use of “void close()” method?
Explain the general ways through which a crm can be enhanced?
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 tap in angular?
What is the purpose of drive object of scripting.filesystemobject class in vbscript?
Two pencils costs 8 cents, then 5 pencils cost how much
What are all the spying modes in blue prism?
What is difference between start imitation and start interlock for 3 phase motor protection ?
can we use mqput1 in java?
How is white-space property of css3 used?
Are there any resources for drop-in replacements for the default css that comes with the ASP.NET Website template?
what is thumb rule for calculating the size of ISMB required for a particular length of span