What is the difference between In-Memory Sort and Inputs
must be sorted?
- 3 Answers
- 22426 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?
Name the different type of processing based on the steps that you know about?
What parallelisms does Abinitio support?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
How will you check the latest versions in EME?
You can ask about different vector functions. How to use in abinitio graph?
What is meant by Co > Operating system and why it is special for Ab-initio ?
what is the difference between ab_work_dir and .work
What do you understand by local lookup?
I am having 10 records in i/p file,and i want to load only one record at a time to the output file.Then how can i do it?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
What is the syntax for m_dump in abinitio?
Teradata 
