Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why Do I Have to Configure Sort Order at the Source Adapter, Rather than at the Consuming Component, for Example Merge?

April 26, 2017adapter component configure consuming merge sort source

0

Posted

Why Do I Have to Configure Sort Order at the Source Adapter, Rather than at the Consuming Component, for Example Merge?

1 Answer

0

Posted

The order of rows is set at the source adapter and cannot be changed by most downstream transforms (Sort would be one exception). Source adapters that are cognizant of the order of sourced data can set this information without user assistance, but in most cases insufficient metadata is provided to a source component to allow it to set output column sort information; as such, the user becomes responsible for this effort.