What is the difference between sequential file and a dataset? When to use the copy stage?

Questions by vsarita80

Showing Answers 1 - 5 of 5 Answers

shiva

  • Jun 29th, 2006
 

Sequential file stores small amount of the data with any extension .txt where as DataSet stores Huge amount of the data and opens the file only with an extension .ds.

  Was this answer useful?  Yes

shiva

  • Jun 29th, 2006
 

Sequentiial Stage stores small amount of the data with any extension in order to acces the file where as DataSet is used to store Huge amount of the data and it opens only with an extension (.ds ) .The Copy stage copies a single input data set to a number of output datasets. Each record of the input data set is copied to every output data set.Records can be copied without modification or you can drop or change theorder of columns.

  Was this answer useful?  Yes

Ravi

  • Oct 27th, 2006
 

hi,

 Main difference b/w sequential file and dataset is : Sequential stores small amount of data and stores normally.But dataset load the data like ansi format.

  Was this answer useful?  Yes

kirupakaran

  • Dec 12th, 2006
 

hi all

sequential file:

it act as a source & permanent storage for target.it 's extend is .txt.

dataset:

it act as a temporary storage stage ,mainly it used before the target stage

while using this stage  the ip datas r partited &convert into internal dataset format.then it is easy to load the data in target stage .

copy:

it act as a placeholder.it has a single ip &many o/p .

if u want 2 add a new stage in ur job at that time it is very easy otherwise u have to modify that whole job.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions