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
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 |
What are junk dimensions?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Describe the impact of several join conditions and join order in a joiner transformation?
where to select code page option?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
How to view and Generate Metadata Reports?
What are events in workflow manager?
What is surrogate key?
wht is full process of Information source to target just like stg to productuon and development
i have source in oracle 10g,oracle 8i how will u take the data from two sources
what is fact table?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .