Is it passive or active when check and uncheck the box of
DISTINCT in Sorter transformation? why?
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 diff between grep and find
Define filter transformation?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
what is the incremental agrrigation?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
what is pre and post sql and what is diff between source presql and target pre sql
what is $$$$?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
which one is better performance wise joiner or look up