What is the difference between In-Memory Sort and Inputs
must be sorted?
Answer Posted / 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 View All Answers
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
How can you import XML repositories exported from different tools like ODI
What is conduct>it?
What are the key elements of a data processing system?
What is data mapping and data modelling?
Do you know what a local lookup is?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Mention what is a partition and what are the different types of partition components in abinitio?
How to run a graph infinitely?
explain the environment varaibles with example?
What is local and formal parameter?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
What exactly do you know about the typical data analysis?
Why might you create a stored procedure with the with recompile option?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?