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 index?how it can work in informatica
Can we create two repositories on same database instance in oracle?
What is a mapplet/worklet in informatica?
What the difference is between a database, a data warehouse and a data mart?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
complex mapping ur project u r invlve can u explain and give real time example give me ?
r u done any partitions in ur project?
What does command task mean?
how we can load rejected record's at run time?(not through bad files)
Under what condition selecting sorted input in aggregator may fail the session?
How to improve the performance of a session using sorter transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the benefit of session partitioning?
How to create a non-reusable instance of reusable transformations?
