Want to sort the data without using sort stage

s_porkalai · Post by **s_porkalai** » Thu Dec 11, 2008 4:54 am

Hi,

Anyone pls suggest me the way to sort the data without using sort stage. This was one of the interview questions i was faced with.

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Thu Dec 11, 2008 5:02 am

And the best answer is "Why?"

The entire philosophy in parallel jobs is "one task one stage type". If you want to sort make it obvious to future developers, by using an explicit Sort stage.

There are two other ways within the ETL tool, and you can also use external methods.

Try a bit of research.

s_porkalai · Post by **s_porkalai** » Fri Dec 12, 2008 12:08 am

Hi

This was an interview question i had faced. If you can solve it, please send me the answer.

srinivas.g · Post by **srinivas.g** » Fri Dec 12, 2008 12:47 am

through link sorting

1.select partitioning method and enable perform sort option in input tab in the perticulat stage properties.

or

2. implement bubble sort logic in transformer

LenGreenwood · Post by **LenGreenwood** » Fri Dec 12, 2008 3:11 am

Setting sort options on the link is really only a GUI cosmetic difference, compared to having a Sort stage on the canvas. The compiled Parallel job will still have the same sort operator in it. And as Ray said, having a Sort stage clearly visible is better practice, really.