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 olap (on-line analytical processing?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the difference between a connected look up and unconnected lookup?
What is substr in informatica?
Define pmcmd command?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the difference between informatics 7x and 8x and what is latest version?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Do you find any difficulty while working with flat files as source and target?
What is an active transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Is there any target staging area in informatica not staging area
Explain informatica architecture - version 8 / 9
What is domain in terms of informatica?
