ETL - What are parameter files ? Where do we use them?

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 16 of 60

What are parameter files ? Where do we use them?

Total Answers and Comments: 3

Last Update: May 12, 2008

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 01, 2005 05:01:29

Harish Dipti

RE: What are parameter files ? Where do we use them?

Parameter file is any text file where u can define a value for the parameter defined in the informatica session, this parameter file can be referenced in the session properties,When the informatica sessions runs the values for the parameter is fetched from the specified file. For eg : $$ABC is defined in the infomatica mapping and the value for this variable is defined in the file called abc.txt as
[foldername_session_name]
ABC='hello world"

In the session properties u can give in the parameter file name field abc.txt

Is this answer useful? Yes | No

January 10, 2006 04:04:29

sithusithu

Member Since: December 2005 Contribution: 161

RE: What are parameter files ? Where do we use them?

You can pass a parameter value to a task using a file, Mostly it will be used in dynamic value assignment

Sithu

Is this answer useful? Yes | No

May 12, 2008 00:54:31

Roger_009

Member Since: March 2008 Contribution: 6

RE: What are parameter files ? Where do we use them?

Parameter files are used for static variable exectuion of a task. this file can b modifies/updated for later change in the parameter. say for ex, xyz="RAJAT" is defined in the parameter file and now whererever XYZ is used in the mapping the data is automatically taken as RAJAT. is we wann achange that we can change that to any other varchar or int in the file.

this file can be called upon in the session properties and shown the physical path in the server to read upon.

Is this answer useful? Yes | No

Go To Top