Sequential File in EE

sami · Post by **sami** » Wed Mar 28, 2007 1:26 pm

Hi,
I am new to DataStage EE. I have to combine 2 files in one sequential file. Reason being I need to bring one column from this other file, and take all columns from first file. If I specify these file names separately and use "read specific files" in read pattern, will this append this extra column to other columns? Please Advice.

Thanks

DSguru2B · Post by **DSguru2B** » Wed Mar 28, 2007 1:28 pm

No. It will read it one by one. For appending you need to join them. Do you have a key on both the files, on which the files will be joined?

sami · Post by **sami** » Thu Mar 29, 2007 8:14 am

Yes. I used a JOIN Stage and it worked. Thanks

DSguru2B · Post by **DSguru2B** » Thu Mar 29, 2007 9:14 am

Great. You can mark your post as "Resolved" then.

timsmith_s · Post by **timsmith_s** » Tue Apr 17, 2007 5:07 am

I have a similar situation - two sequential files going into a join. However, for a join to work, the links must be sorted/key partitioned.

What would be best practice - set the sort/part keys on the output link of the sequential files or have an explicit sort stage between each file-to-join links?

ray.wurlod · Post by **ray.wurlod** » Tue Apr 17, 2007 5:13 am

You can only specify sort on the input link(s) to a stage.

On-link sorting and Sort stage perform exactly the same sort function, using a tsort operator. However an explicit Sort stage gives you better control over the amount of memory allocated for sorting, and to specify that the data are already sorted - if this is known to be true - so that they do not have to be re-sorted.