Why we need datasets ratherthan sequential files?

Answer Posted / chiranjeevi.a

To over come the limitation of sequential file,espesially
sequential file: By default reads and writes sequentially
>memory limit is up to 2GB
>conversion is needed
>sourse stores the data out side of datastage
Data file:
>parallel process
>memory is unlimited
>No conversion is needed while reading the data(its
basically in native format).
>stores data inside the repositary

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is 'reconsideration error' and how can i respond to this error and how to debug this

2127


How many types of hash files are there?

616


what is the use of surogate key in datastage

1825


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4572


what is ds administrator used for?

728






What are the stages in datastage?

641


Is the value of staging variable stored temporarily or permanently?

585


Notification Activity

903


Differentiate between data file and descriptor file?

623


What is the importance of the exception activity in datastage?

630


What are the types of containers and how to create them?

562


Why we use surrogate key?

701


What are the types of jobs we have in datastage?

678


On which Dimension Table you implemented SCD Type in your Project

1588


Enlist various types of routines in datastage.

648