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
- 17244 Views
- iFlex, Morgan Stanley, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a surrogate key?
How many types of sessions are there in informatica.please explain them?
What is lookup change?
What's the layout of parameter file (what does a parameter file contain?)?
Under what condition selecting sorted input in aggregator may fail the session?
What is update strategy transform?
What is the use of transformation?
What are the differences between oltp and olap?
How you can differentiate between connected lookup and unconnected lookup?
Difference between Data and Index Caches?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Does an informatica transformation support only aggregate expressions?
What is meant by a domain?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Differences between connected and unconnected lookup?
