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
Describe what the SQL Server tempdb and tlog files are used for?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
Mention what is rollup component?
What is a partition and what are the different types of partition components in abinitio?
What do you mean by a transaction file and how it is different from that of a sort file?
What are the key elements of a data processing system?
What is data encoding?
What is is a data flow graph?
Tell us about the architecture of abinitio.
What is the purpose of having stored procedures in a data-based?
What is the function you would use to transfer a string into a decimal?
Can anyone give me an exaple of realtime start script in the graph?
List out the file extensions used in abinitio?
What is the difference between check point and phase?
Pdl with an example?