Is it passive or active when check and uncheck the box of
DISTINCT in Sorter transformation? why?
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by LDAP users?
What is a passive transformation?
What does cheating measurement mean?
What is the session task and command task?
What is a shortcut and copy in Informatica and how two are different with each other?
what is the -ve test case in your project.
What is lookup change?
Why filter transformation is an active one?
How to improve the performance of a session using sorter transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
In which transformation you cannot drag ports into it?
Can anyone tell me the new features in Informatica 9 Version?
Is it possible to create multiple domains on a single Informatica server?
What are connected or unconnected transformations?
how many types of dimensions are available in informatica?