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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / rishi

@ Mahendra,

So u r saying that even if the input dataset is sorted (on
the driving port) and u select in-memory sort then still
the output will be unsorted ?????

Is This Answer Correct ?    5 Yes 2 No

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

Answer / mahendra patnaik

The Inmemory sort and input must be sorted options are
there in the Join,Rollup and Dedup components.
Main difference between these two is if you selected input
must be sorted options in the above mentioned components
the the downstream components will get the records in a
sorted oder. if you are selected option as Inmemory sort
then the downstream components will not get the sorted
records.

Is This Answer Correct ?    1 Yes 13 No

Post New Answer

More Ab Initio Interview Questions

Have you worked with packages?

0 Answers  


What is the default layout of a component ? Is it mandatory to set the layout of a component ?

3 Answers   IBM,


When we should use 'jobid' for commit table (Output table component??

1 Answers   HCL,


Hi friends i have 3 input files 1 is country file(cid,cname) 2 is State file(cid,sname) 3 is populate file(pid,sid,Adress) I want (cname & total poplation) how i can get the output please help me Thank you

1 Answers  


What is the difference between rollup and scan?

0 Answers  






What is the difference between a utility and api in a RUN SQL component

1 Answers   Accenture,


What does de-partition mean in abinitio?

0 Answers  


How can you view the data in the Multifile

4 Answers   IBM,


Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

0 Answers  


What are the factors on which storage of data depends?

0 Answers  


Give one reason when you need to consider multiple data processing?

0 Answers  


how can you convert 3 way to 7way partitioning in abinitio?

4 Answers  


Categories