1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / devi

Answer Posted / devi

Save PARAMETER file with .prm extension.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

609

What's the layout of parameter file (what does a parameter file contain?)?

1917

What is joiner change?

679

What is a sequence generator transformation?

577

How are the sources and targets definitions imported in informatica designer?

668




How can we update a record in the target table without using update strategy?

656

How to load a Dimension ? and how to load a fact table?

955

How can we store previous session logs?

567

What is the benefit of session partitioning?

595

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1588

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

562

Differentiate between Load Manager and DTM?

1665

What is a repository? And how to add it in an informatica client?

655

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1697

What is an unconnected transformation?

666