when will you go for dataset and fileset?

Answers were Sorted based on User's Feedback



when will you go for dataset and fileset?..

Answer / jaimy chacko

just want to add something to the previous answer

Data sets are operating system files,
each referred to by a control file, which by
convention has the suffix .ds.
The control file points IBM InfoSphere DataStage
to a set of other files that carry the data.
The location of these data files is determined by the “resource disk” property in the configuration file used to run the job. Using data sets wisely can be key to good performance in a set of linked jobs.
You can also manage data sets independently of a job using the Data Set Management utility, available from
the IBM InfoSphere DataStage and QualityStage Designer or Director.

WebSphere 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. The amount of data that can be stored in each destination data file is limited by the characteristics of the file system and the amount of free disk space available.

Is This Answer Correct ?    8 Yes 4 No

when will you go for dataset and fileset?..

Answer / jaimy chacko

Dataset and Fileset are almost the same .

Dataset is tool dependent and File Set is OS dependent(UNIX).
Dataset don't have any regulation of the amount of data that it has where as Fileset have limits to the data.

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More Data Stage Interview Questions

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,


What is ibm datastage flow designer?

0 Answers  


what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,


What are the various kinds of the hash file?

0 Answers  


types of errors in datastage?

2 Answers   Reliance,






How to Convert the columns into rows?

2 Answers  


how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,


what is repositery?

0 Answers   IBM,


what is normalization and denormalization

2 Answers   CTS,


what r the sources u need to create the datastage?

1 Answers  


What is the difference between the local container and shared container?

0 Answers  


What all the types of jobs you developed?

0 Answers  


Categories