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
- 17248 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 |
What is sorter transformation?
what is the difference between stop and abort?
disable caching in a lookup transformation?
Explain in detail about scd type 1 through mapping.
how to return multiple columes through through un-connect lookup?
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Enlist few areas or real-time situations where informatica is required.
what is procedure to use mapping variable in source qualifier transformation? with example
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
one source to target loading insert new rows and update existing rows?
What is predefined event?
Teradata 
