Interested to Buy Any Domain ? << Click Here >> for more details...
Is it passive or active when check and uncheck the box of
DISTINCT in Sorter transformation? why?
- 6 Answers
- 17015 Views
- iFlex, Morgan Stanley, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saritha
It is Active transformation.
If you configure the Sorter transformation for distinct
output rows, the Mapping Designer configures all ports as
part of the sort key. When the PowerCenter Server runs the
session, it discards duplicate rows compared during the
sort operation.
| Is This Answer Correct ? | 36 Yes | 0 No |
Answer / suchi
Sorter Transformation is passive when the DISTINCT option
is unchecked bcoz it wont change the number of records
passes through it. Once the DISTINCT option is checked it
may change the no of records if the records has duplicates.
| Is This Answer Correct ? | 25 Yes | 14 No |
Answer / deepu
I sorter is an Active Transformation,I u check the Distinct
option it will output only the distint rows from the
source .
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / saradhi
if we check the box distinct means u are eliminating the
duplicate record.so here if we check the distinct while
sorting its eliminating the duplicate records and after its
sorts so the number of records in target are less compared
to source for that it is calles as active. if we uncheck
this all the records are transforms into target table so it
is passive.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / hema
sorter transformation is behaving like a passive but it must be active transformation because select distinct option then it will change number of records/rows otherwise uncheck the distinct option it doesnot change the recods so is this correct answer
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / arun
it is active transformation, if u uncheck or check the
sorterport there is option for sorting the data if u check
this option it will change the rows if u uncheck this the
same data will pass to the target. but check in the
expression t/r there is no option like sorter t/r.
| Is This Answer Correct ? | 1 Yes | 11 No |
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
i have 2 session s1 execute s2 load first session fail what is the reason?
What is the Difference between PowerPlay transformer and power play reports?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
difference between stop and abort
why union transformation is active transformation?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
What is a sorter transformation?
In update strategy target table or flat file which gives more performance ? why?
What is a rank transform?
Why we need XMLs?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
Teradata 
