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
- 9120 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / shantu
I THINK THERE IS NO DIFFERENCE BETWEEN .TXT AND .PRM, SOMETIMES IT MAY DIFFER BUT ALL THE CASES
CORRECT ME IF I'M WRONG
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Why update strategy and union transformations are active?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a difference between complete, stop and abort?
How many ways are there to create ports?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What are the types of caches in lookup? Explain them.
What does reusable transformation mean?
Write the prerequisite tasks to achieve the session partition?
What do you mean incremental aggregation?
How many ways a relational source definition can be updated and what are they?
Write the program through which the records can be updated?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What does command task mean?
Explain what transformation and how many are there in informatica?
