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

Which warehouse using in your datawarehouse

1686


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

562


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

2550


What is the difference between operational data stage (ods) and data warehouse?

679


What is aggtorec restructure operator?

732






How do you import and export data into datastage?

707


what is the use of skid in reporting?

1961


Can you explain repository tables in datastage?

909


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2440


What are the different plug-ins stages used in your projects?

630


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

671


how to implement scd2 in datastage 7.5 with lookup stage

5135


How do you generate sequence number in datastage?

629


Can you explain how could anyone drop the index before loading the data in target in datastage?

904


Explain the datastage parallel extender (px) or enterprise edition (ee)?

746