Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are the uses of a Parameter file?

Answers were Sorted based on User's Feedback



What are the uses of a Parameter file?..

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

What are the uses of a Parameter file?..

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

What are the uses of a Parameter file?..

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

Post New Answer

More Informatica Interview Questions

What are the tasks that source qualifier perform?

0 Answers   Informatica,


i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,


Enlist the various types of transformations.

0 Answers  


what is the difference between stop and abort?

3 Answers   TCS,


What are variable ports and list two situations when they can be used?

1 Answers  


Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,


Two different admin users created for repository are ______ and_______

1 Answers  


What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,


What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,


suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,


without using emailtask how will send a mail from informatica?

3 Answers  


wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,


Categories