Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Informatica PR000041 Exam - Topic 1 Question 9 Discussion

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

Informatica PR000041 Exam - Topic 1 Question 9 Discussion

Actual exam question for Informatica's PR000041 exam
Question #: 9
Topic #: 1
[All PR000041 Questions]

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

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Carissa
8 months ago
C is misleading, it actually produces all records unless distinct is checked.
upvoted 0 times
...
Elmira
9 months ago
Wait, D can't be true, right? Sorter doesn't use database indexes!
upvoted 0 times
...
Yaeko
9 months ago
B sounds right, sorting every record makes sense for transactions.
upvoted 0 times
...
Shantay
9 months ago
I disagree with A, I think it depends on the configuration.
upvoted 0 times
...
Madalyn
9 months ago
A is definitely true, all ports need sort keys if distinct is checked.
upvoted 0 times
...
Kaycee
9 months ago
I vaguely remember that the Sorter transformation doesn’t use database indexes for sorting, so option D might be incorrect.
upvoted 0 times
...
Pura
9 months ago
I’m pretty confident that if the distinct checkbox isn’t checked, the sorter doesn’t limit to unique keys, so option C seems off to me.
upvoted 0 times
...
Quentin
9 months ago
I think option B sounds familiar from our practice questions, but I can't recall if it really sorts every record before releasing data.
upvoted 0 times
...
Myra
9 months ago
I remember something about the distinct checkbox, but I'm not sure if it affects all ports or just the ones selected.
upvoted 0 times
...
Josefa
9 months ago
This seems like a straightforward question about iOS device behavior. I'll carefully read through the options and think about what the "NotNow" event could indicate.
upvoted 0 times
...
Reiko
9 months ago
Hmm, I'm a bit unsure about this one. The details about the scam seem clear, but I'll need to carefully analyze each option to determine which one is incorrect.
upvoted 0 times
...
Adell
9 months ago
I'm a bit confused—does "failure" relate to the chance of something going wrong, or is it more about the consequences? I hope I get this right!
upvoted 0 times
...
Moira
10 months ago
Based on the error, it seems like I need to open a support case to request additional GKE quota. That's probably the safest way to get this resolved.
upvoted 0 times
...

Save Cancel