Interested to Buy Any Domain ? << Click Here >> for more details...
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
How will the document be delivered to me?
What is the way to execute pl/sql script using informatica mapping?
How to create or import flat file definition in to the warehouse designer?
Explain lookup transformation is active in informatica
What is an active transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
In how many ways we can create ports?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the tuning techniques you applied during your last project
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the new features of informatica 9.x developer?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is the difference between informatica 7.0 and 8.0?
write a query to retrieve the latest records from the table sorted by version(scd)
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
