Why we need datasets ratherthan sequential files?

Answer Posted / kiran

First we Know about Seq file and Dataset.

Seg file is used Extract the from flatfiles and load into
flatfiles and limit is 2GB

Dataset is a intermidiate stage and it has paralism when
load data into dataset and it inprove the performanece.

Is This Answer Correct ?    22 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to implement scd2 in datastage 7.5 with lookup stage

5121


Define orabulk and bcp stages?

669


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2532


What is ds designer?

645


How to clean the datastage repository?

688






What is a merge in datastage?

761


What are stage variables and constants?

694


Why we use surrogate key?

694


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1660


What is apt_config in datastage?

697


What is difference between server jobs & parallel jobs?

617


What are the types of containers in datastage?

697


Differentiate between datastage and datastage tx?

586


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2303


AGGREGATOR default datatype

926