Regarding the Sorter Transformation and Assuming That Powercenter Is Not

question 47

Multiple Choice

Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:

• A) When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled
• B) When transformation scope is set to a value of transaction, the sorter will sort on every record in the pipeline before it releases any data. The intermediate sort file will have markers for each transaction.
• C) If the distinct check box is not checked, the sorter will produce one record per unique key
• D) The Sorter transformation will utilize database indexes from the source database to perform the sort

---

Definitions:

LGBTQ Women

Women who identify as lesbian, gay, bisexual, transgender, queer, or questioning and are part of the wider LGBTQ community.

Workplace

The physical or virtual location where work is carried out.

Workplace Stereotypes

Oversimplified and generalized beliefs or perceptions about characteristics, attributes, and behaviors of individuals based on their occupation or professional role.

CEOs

Chief Executive Officers, the highest-ranking individuals in a company or organization, responsible for making major corporate decisions.