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
Design a mapping to load a target table with the following values from the above source?
What is target designer and target load order?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain pushdown optimization $pushdownconfig parameter - informatica
What is rank transform?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is rank transformation in informatica
What is a mapplet/worklet in informatica?
What is mapping debugger?
What is rank transformation?
What differs when we choose the sorted input for aggregator transformation?
What is the use of transformation?
design of staging area?
During the running session, output files are created by informatica server. Enlist few of them.
What is meant by LDAP users?