Answer Posted /
| Is This Answer Correct ? | Yes | No |
Post New Answer View All Answers
'A class is a template for an object' explain this statement.
What is a product cipher?
what is the difference between .dll and .exe
How do I partition a table in sql server?
What is the meaning of the deq command?
What is the use of System.XML.XLinq..dll in LINQ?
What does @param args mean in java?
What is a constraint?
what is the role of auxins in floral bud development and fruit development?
Differentiate call by value and call by reference?
What are the advantages of using sap hana db over other traditional database for bi reporting? : hana bi development
What is the maximum size of csv file?
WHAT IS THE DIFFERENCE BETWEEN BRAND AND A COMPANY?
Compare and contrast compilers from interpreters.
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