Parameter files are created with an extesion of .PRM These are created t

What are the uses of a Parameter file?

Question Posted / d s r krishna

3 Answers
13839 Views
CSC, I also Faced
E-Mail Answers

Answer Posted / d s r krishna

Parameter files are created with an extesion of .PRM

These are created to pass values those can be changed for
Mapping Parameter and Session Parameter during Mapping run.

Mapping Paramters:
A Parameter is defined in a parameter file for which a
Parameter is create already in the Mapping with Data Type ,
Precision and scale.

The Mapping parameter file syntax (xxxx.prm).
[FolderName.WF:WorkFlowName.ST:SessionName]
$$ParameterName1 =Value
$$ParameterName2 =Value

After that we have to select the properties Tab of Session
and Set Parameter file name including physical path of this
xxxx.prm file.

Session Parameters:

The Session Parameter file syntax (yyyy.prm).
[FolderName.SessionName]
$InputFileValue1=Path of the source Flat file

After that we have to select the properties Tab of Session
and Set Parameter file name including physical path of this
yyyy.prm file.

Do following changes in Mapping Tab of Source Qualifier's
Properties section
Attributes values

Source file Type ---------> Direct
Source File Directory --------> Empty
Source File Name --------> $InputFileValue1

Thanks

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can repository reports be accessed without sql or other transformations?

1268

How to delete duplicate row using informatica?

1089

can we override a native sql query within informatica? How do we do it?

1186

What is meant by target load plan?

1029

What is an active transformation?

1159

can u give example for factless fact table

6781

What is target designer and target load order?

1170

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1846

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2113

How to load data in informatica ?

1069

Explain sessions. Explain how batches are used to combine executions?

1080

Explain how to import oracle sequence into informatica?

1071

Can we create a Integration service without a Repository service and vice versa?

1258

What is a sequence generator transformation?

1073

How might one distinguish in the case of mapping is right or not without associating session?

1197