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
- 16671 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 are 3 tech challenges/ common issues you face?
What is data transformation manager process?
What is sequence generator transformation in informatica?
What all are steps in up gradation of Informatica server?
What are the new features of Power Center 5.0?
How to start a workflow using pmcmd command?
generate date / time dimension in informatica
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
can we override a native sql query within informatica? How do we do it?
What is Index Caches size?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
difference between informatica 8.1.1 and 8.6
How to Create a folder using pmrep command?
How to join three sources using joiner?
Explain in detail about scd type 1 through mapping.
