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
- 8938 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / devi
Save PARAMETER file with .prm extension.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
State the differences between sql override and lookup override?
What is DR strategy for Informatica project?
Which development components of informatica have the highest usage?
What are session parameters ? How do you set them?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is the size of u r source(like file or table)?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are data-driven sessions?
Briefly define a session task?
What is informatica etl tool?
How to use procedural logic inside infromatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
