What is the difference between In-Memory Sort and Inputs
must be sorted?

Answer Posted / duffer

When set to In memory: Input need not be sorted, the
component accepts unsorted input and permits the use of the
maintain-order parameter. Component sorts records
internally in its buffer.

When set to Inputs must be sorted, the component requires
sorted input, and the maintain-order parameter is not
available.

Default is Inputs must be sorted.

Is This Answer Correct ?    19 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

647


Explain the methods to improve performance of a graph?

670


What is the difference between formal and export parameter? Export at what secenario we are going to use?

2139


What is de-partition in abinitio?

882


what is the difference between i)public ii)private iii)common and client projects?

1684






What is the architecture of abinitio?

662


What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

628


Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

652


What would be the next step after collecting the data?

724


What happens when we provide null key to sort, merge and pbks in Abinitio ?

815


Mention what is rollup component?

639


What do you understand by a cartesian join?

656


Is data warehousing different from data mining?

631


What is common among data validity and data integrity?

594


What is rollup component?

679