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
- 9135 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the new features of informatica 9.x at the developer level?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How many types of sessions are there in informatica.please explain them?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to load the data from a flat file into the target where the source flat file name changes daily?
Different circumstance which drives informatica server to expel records?
Why do you use Mapping Parameter and mapping variable?
Which are the different editions of informatica powercenter that are available?
Enlist the differences between database and data warehouse.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain the etl program with few examples.
have u done any performance tuning? how u ll do?
what are 3 tech challenges/ common issues you face?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
scenario where i can use only concurrent execution of workflow.
