ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Stage
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
when will you go for dataset and fileset?
 Question Submitted By :: Vijay
I also faced this Question!!     Rank Answer Posted By  
 
  Re: when will you go for dataset and fileset?
Answer
# 1
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 ?    1 Yes 0 No
Jaimy Chacko
 
  Re: when will you go for dataset and fileset?
Answer
# 2
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 ?    0 Yes 0 No
Jaimy Chacko
 
 
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...  2
HOW CAN WE SEE THE DATA IN DATASET? IBM2
When we will go for Data elements? TCS3
How can you find out whether datastage process is running or not in unix? Accenture1
what is Audit table?Have u use audit table in ur project? Wipro1
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS? ME2
What modeling tool do you use? HP5
wt is the difference between swith and filter stage IBM2
How can we run same job in 1 day 2 times IBM3
can we use sequential file as a lookup Wipro4
what is usage of datastage with materialized views HP1
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..  1
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project? Wipro2
1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use? Wipro3
how do u capture duplicates through sort & transformer  1
How did you reconcile source with target? HP2
what about data stage requirement  1
how to do pergformence tuning in datastage? Symphony3
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY? L&T1
What is lookup table?  3
 
For more Data Stage Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com