I THINK THERE IS NO DIFFERENCE BETWEEN .TXT AND .PRM, SOMETIMES IT MAY DIFF

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 / shantu

4 Answers
8934 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

Please Help Members By Posting Answers For Below Questions

What all join we can perform in LOOKUP transformation?

913

What is deployment group?

1126

What is session task and command task?

1174

What are active and passive transformations?

1017

Can you use flat files in Mapplets.

2609

where to store informatica rejected data?

1045

What is the format of informatica objects in a repository?

972

Difference between Data and Index Caches?

1090

What is a filter transformation and why it is an active one?

905

Slowly changing dimensions, types and where will you use them

1653

What are the new features of informatica 9.x developer?

899

What are the static cache and dynamic cache in informatica?

1138

What do think which one is the better joiner or look up?

1143

What are junk dimensions?

1019

What is substr in informatica?

1132