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
- 9140 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
what is informatica metadata?
What are the components of workflow manager?
What is option by which we can run all the sessions in a batch simultaneously?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Tell me about MD5 functions in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain constraint based loading in informatica
have u done any performance tuning? how u ll do?
Clarify the utilization of aggregator cache record?
What is the difference between source qualifier transformations source filter to filter transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Suppose we do not group by on any ports of the aggregator what will be the output?
What do you mean incremental aggregation?
What is a sorter transformation?
What is pmcmd command?
