Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - Why we need datasets rather than sequential files?




1853
views
asked mar September 20, 2014 06:33 AM  

Why we need datasets rather than sequential files?


           

1 Answers



 
answered By vishnoiprem   0  
file set is  collection of sequential files.
if source database is greater than 2 GB than prefer to use file set.

Data set is internal stage in datastage.
The extension of data set is .ds it never used to extract data from client location .
it is used as intermediate stage between two tables.
Sequential :
It supports all formats like txt,csv,xls,etc.
it is used to extract data from flat files from client location.

Data set:

it supports only .ds format
It will never extract data from flat files from client location.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert