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
- 9300 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
What is option by which we can run all the sessions in a batch simultaneously?
What are the types of maping in Getting Started Wizard?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Do you have to change the reject file b4 using reject loader utility.
daily how much amount of data send to production?
How to import oracle sequence into Informatica?
Have you worked with/created Parameter file
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
How many ways you create ports?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
How to delete duplicate row using informatica?
Teradata 
