Interested to Buy Any Domain ? << Click Here >> for more details...
What are the uses of a Parameter file?
- 3 Answers
- 13696 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bhaskar
Parameter file is one which contains the values of mapping
variables.
type this in notepad.save it .
foldername.sessionname
$$inputvalue1=
in the session properties,under parameter file path specify
the path where this notepad is saved
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rahul
parameter file ---- we have parameters and variable.
we can use than in mapping, session and work flow.
session: to change the cache path
workflow ; to know the status of prev tast.
mapping: to maintain constant value or to use last upadated
value
| Is This Answer Correct ? | 1 Yes | 0 No |
how do the project develops? pls specify right from the start to end in step by steps.
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What do mean by local and global repository?
What is diff joiner and lookup
How to update a particular record in target with out running whole workflow?
How to delete duplicate row using informatica?
What is informatica metadata and where is it stored?
difference between shortcut and reusable transformation?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
Teradata 
