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
- 16994 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 |
in realtime which situations u can use unconnected lookup transformation
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
Explain your project of banking domian.
Can we get 1st record through Informatica(without sequence number).
What is router transformation
Is there any target staging area in informatica not staging area
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
what is the diff b/w target load plan and cbl?
permutations of mapplet
what are the output files that the informatica server creats during running a session?
What is a dimensional model?
can v update d records in target using update stargey without generationg primary key ? explain
Teradata 
