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
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 is InformaticaPowerCenter?
What is mapplet in informatica?
Explain what are the different types of transformation available in informatica.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is an expression transformation in informatica?
Can we override a native sql query within informatica?
Enlist the various types of transformations.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is meant by active and passive transformation?
How to extract sap data using informatica? What is abap? What are idocs?
What is an aggregator transformation?
How does the aggregator transformation handle null values?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
how to load dimension table and fact table. plz tell me the steps.