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 tasks that source qualifier perform?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
Enlist the various types of transformations.
what is the difference between stop and abort?
What are variable ports and list two situations when they can be used?
Enterprise data warehouse your projects phase by phase explain?
Two different admin users created for repository are ______ and_______
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is the filename which you need to configure in UNIX while installing infromatica?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
without using emailtask how will send a mail from informatica?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..