Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 8937 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / mai phuong
I have fixed it. This was because in parameter file I did
not declare the name of folder, workflow and session
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Write the unconnected lookup syntax?
whats the logic to load the lower level of granularity of data to fact table.
How to differentiate between the active and passive transformations?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is data transformation manager process?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the different versions of informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Under what condition selecting sorted input in aggregator may fail the session?
What is the difference between source qualifier transformations source filter to filter transformation?
How an expression transformation differs from aggregator transformation?
During the running session, output files are created by informatica server. Enlist few of them.
Explain about Informatica server process that how it works relates to mapping variables?
