What are the uses of a Parameter file?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bhaskar
Parameter file is one which contains the values of mapping
variables.
type this in notepad.save it .
foldername.sessionname
$$inputvalue1=
in the session properties,under parameter file path specify
the path where this notepad is saved
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rahul
parameter file ---- we have parameters and variable.
we can use than in mapping, session and work flow.
session: to change the cache path
workflow ; to know the status of prev tast.
mapping: to maintain constant value or to use last upadated
value
Is This Answer Correct ? | 1 Yes | 0 No |
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the difference between Normal load and Bulk load?
What is option by which we can run all the sessions in a batch simultaneously?
What is event and what are the tasks related to it?
How to create a non-reusable instance of reusable transformations?
Differentiate between source qualifier and filter transformation?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
what is the predefined port in dynamic lookup
What are the data movement modes in informatcia?
How many transformations can be used in mapplets.
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.