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 dimensional table?
How to use procedural logic inside infromatica?
design of staging area?
Whats there in global repository
Mention few power centre client applications with their basic purpose?
What is a repository? And how to add it in an informatica client?
What is the difference between informatics 7x and 8x and what is latest version?
What is a predefined event?
What are the new features of informatica 9.x developer?
What is the need of an ETL tool?
What are the data movement modes in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
Differentiate between joiner and lookup transformation?
What is a code page?
What are the types of caches in lookup? Explain them.