tell me about yourself ?57 245230
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 best way to create a Thread class & why?
What is the difference between VARCHAR and NVARCHAR in SAP HANA SQL?
whether allowances will be included in calculating esi from gross salary
What are all the components require Publish when they update in system?
For exanple If i transfer money from ICICI to SBI, where is suspense account created? Explain the money transfer process?
what is the techanical difference between german standard & japanese standard.
list the advantages of RCCB over other circuit breakers?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
Why the Family Owned Companys' Does not Understand & not giving IMPORTANCE for Human Resource Department in their Business ?
string reverse using recursion
5. Which of the following can you do with DB2 Express- C? Query databases with SQL Query databases with XML using XQuery and XPath Use SQL in Xquery and Xquery in SQL All of the above
What is meant by Error Log ?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Isometric drawings are generated during _________________ phase of a project