What is the difference between In-Memory Sort and Inputs
must be sorted?
- 3 Answers
- 23405 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 |
What do you mean by a transaction file?
What is the significance of ‘mp run’ command ?
Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...
what are the steps in actual ab initio graph processing including general,pre and post process settings?
how to prepare scd2 in abinitio
Mention what dedup-component and replicate component does?
can we perform checkin and checkout through sandbox?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
How to connect mainframe to Abinitio?
How do we handle if DML changing dynamicaly?
5 Answers GE, HP, IBM, Mannar Company,
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
Have you ever encountered an error called “depth not equal”?
Teradata 
