DSXchange

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

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.

Hi

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

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

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.