GeekInterview.com
Series: Subject: Topic:
Question: 489 of 645

what is data set? and what is file set?

Asked by: Interview Candidate | Asked on: Mar 13th, 2006
Showing Answers 1 - 7 of 7 Answers
satheesh_color

Answered On : Mar 15th, 2006

View all answers by satheesh_color

I assume you are referring Lookup fileset only.It is only used for lookup stages only.Dataset: DataStage parallel extender jobs use data sets to manage data within a job. You can think of each link in a job as carrying a data set. The Data Set stage allows you to store data being operated on in a persistent form, which can then be used by other DataStage jobs.FileSet: DataStage can generate and name exported files, write them to their destination, and list the files it has generated in a file whose extension is, by convention, .fs. The data files and the file that lists them are called a file set. This capability is useful because some operating systems impose a 2 GB limit on the size of a file and you need to distribute files among nodes to prevent overruns.

  
Login to rate this answer.
srinivas

Answered On : Apr 14th, 2006

file set:- It allows you to read data from or write data to a file set. The stage can have a single input link. a single output link, and a single rejects link. It only executes in parallel modeThe data files and the file that lists them are called a file set. This capability is useful because some operating systems impose a 2 GB limit on the size of a file and you need to distribute files among nodes to prevent overruns. Datasets r used to import the data in parallel jobs like  odbc in server jobs

  
Login to rate this answer.
Metilda

Answered On : Dec 3rd, 2009

View all answers by Metilda

The Data Set is a File Stage. It allows you to read Data from or to write data to a data set. The stage can have a single input link or a single output link. It can be configured to execute in parallel or sequential mode.

  
Login to rate this answer.
vamsi

Answered On : Jan 21st, 2012

In lookup stage dont have option to perform the operation with the fileset because file set is native format so we can access the file set through lookup file set and also filse set is a operating system file.

  
Login to rate this answer.
Anil Kumar

Answered On : Jan 22nd, 2012

A dataset is a file/stage where the data can be read directly by the datastage OS whereas a file set need to be converted into datstage readable format which happens internally.

In simple words the data from the dataset can be read faster then from fileset.

  
Login to rate this answer.
arjun

Answered On : Jan 25th, 2012

The fundamental concept of the Orchestrate framework is the Data Set. Data Sets are the inputs and outputs of Orchestrate operators.

As a concept a Data Set is like a database table, in so far as it is a collection of identically-defined rows. It is the only structure on which Orchestrate operators (of which more later) operate. Each operator accepts input from one Data Set and sends its output to another Data Set.

A Data Set exists on all the processing nodes defined for the job that is currently processing it. That subset of rows in a Data Set that are located on a single processing node is referred to as a "partition" of the Data Set. Technically, a partition is a subset of the rows in a Data Set (or File Set) earmarked for processing on the same processing node.

A control file is associated with each data set. The control file contains the record schema that defines the row structure (effectively its column definitions).

Within a Data Set data are stored in internal, or machine-compatible format.

  
Login to rate this answer.
praveen

Answered On : Apr 28th, 2012

Data set and file set are file/stage ,these to are data extract from db.in the data set does not have rejected link file set had rejected link

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.