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
What is the status code in stored procedure transformation?
What is the use of an aggregator cache file?
Differences between version 7.x and 8.x.
What is the use of target designer?
can u any challenge your project?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the reusable transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How can we remove the duplicates from flat file source?
Can we create two repositories on same database instance in oracle?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are connected or unconnected transformations?
what are the deliverables?in your project?
What is a shortcut and copy in Informatica and how two are different with each other?
What is the use of transformation?