Informatica Exam PR000041 Topic 1 Question 9 Discussion

Actual exam question for Informatica's PR000041 exam

Question #: 9
Topic #: 1

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

AWhen the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled

BWhen 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.

CIf the distinct check box is not checked, the sorter will produce one record per unique key

DThe Sorter transformation will utilize database indexes from the source database to perform the sort

Show Suggested Answer

Suggested Answer: A

by Laurel at May 08, 2022, 09:11 AM

Limited Time Offer

25%

Off

Get Premium PR000041 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!