Kiran Kumar Cholleti

• Jun 16th, 2006

 

 It allows to sort data either in ascending or descending order according to a specified field. Also used to configure for case-sensitive sorting, and specify whether the output rows should be distinct. then it will not return all the rows

madugula

• Jun 28th, 2006

 

becz it will change the rowid of the records transformed.

active transformation:is no of records and thier rowid that pass through the transformation will differ.

sandeep

• Jun 28th, 2006

 

This is type of active transformation which is responsible for sorting the data either in the ascending order or descending order according to the key specifier. the port on which the sorting takes place is called as sortkeyport

  properties

 if u select distinct eliminate duplicates

case sensitive  valid for strings to sort the data

null  treated low   null values are given least priority

bala

• Jul 6th, 2006

 

If any transformation has the distinct option then it will be a active one,bec active transformation is nothing but the transformation which will change the no. of o/p records.So distinct always filters the duplicate rows,which inturn decrease the no of o/p records when compared to i/n records.

One more thing is"An active transformation can also behave like a passive"

veena

• Jun 13th, 2012

 

Actually sorter is passive transformation only it send data either in ascending or descending order to the targets by using sort key.
We have one option in properties tab is Distinct
if we select that option it remove duplicates, in that case sorter is ACTIVE transformation.

Santosh Desetti

• Jun 14th, 2012

 

Sorter T/R is Passive T/R Because it have the distinct property. If we check that distinct property then it will not allows the distinct values So it a passive T/R. If we dont check the Distinct property then it behaves like Passive T/R.

So Sorter T/R is can change the records by distinct property so its a Passive T/R

vishalkrishan

• Jun 19th, 2012

 

The Sorter transformation is an Active transformation because its attribute, Distinct provides a facility to remove duplicates from the input rows.

jayapraveen

 Profile Answers by jayapraveen 

• Jun 21st, 2012

 

Actually Sorter acts as both passive/Active if we check the Distinct Property then it acts as Active othewrwise passive