Kiran Kumar Cholleti
Answered On : 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
1 User has rated as useful.
Login to rate this answer.
madugula
Answered On : 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.
Login to rate this answer.
sandeep
Answered On : 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
Login to rate this answer.
bala
Answered On : 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"
Login to rate this answer.
veena
Answered On : 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.
Login to rate this answer.
Santosh Desetti
Answered On : 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
Login to rate this answer.
vishalkrishan
Answered On : Jun 19th, 2012
The Sorter transformation is an Active transformation because its attribute, Distinct provides a facility to remove duplicates from the input rows.
Login to rate this answer.
Actually Sorter acts as both passive/Active if we check the Distinct Property then it acts as Active othewrwise passive
Login to rate this answer.
