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
What is data caches/ index caches?
Define filter transformation?
What is the Rank index port in Rank transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the use of an aggregator cache file?
How to generate sequence numbers using expression transformation?
What do you mean by filter transformation?
what are the deliverables?in your project?
What are the different types of repositories created using informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Differences between connected and unconnected lookup?
How do you set a varible in incremental aggregation
what is index?how it can work in informatica
Briefly define reusable transformation?
