when will you go for dataset and fileset?
Answer Posted / 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 |
Post New Answer View All Answers
How many areas for files does datastage have?
What is meta stage?
How to implement complex jobs in data stage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
what is the use of surogate key in datastage
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How many types of views are there in a datastage director?
What is size of a transaction and an array means in a datastage?
How do you import and export the datastage jobs?
What are the steps required to kill the job in Datastage?
Why do you need stage variables?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this