Regarding In Link sort

dstest · Post by **dstest** » Mon May 26, 2008 2:20 pm

Is in link sort use datastage scratch space or memory.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon May 26, 2008 4:17 pm

Memory first then, if that becomes exhausted, scratch disk. The amount of memory allocated to tsort operators is governed by an environment variable.

dstest · Post by **dstest** » Mon May 26, 2008 6:33 pm

I have a file which contains 40million records and i need to sort the file 5 times using different keys and then take the unique record for each group.

So what is the best way to acheive this whether to use inmemory sort and take unique record or sort by using external sort stage and keed unique record.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon May 26, 2008 7:10 pm

In memory. Five explict Sort stages, which allows you the ability not to sort on any already sorted/grouped key, yet to preserve that sorting order.