Output for sort and dedupsort with NULL key?

Answer Posted / mahendra garewal

Your result will come as per you specify the first/last
record. as it does not sort the records.

ex:
Input
A B C
----------
1 a d
4 f h
6 y g
7 g u
2 i o

Output
a: if selected first record in dedup
A B C
----------
1 a d

b: if selected last record in dedup
A B C
----------
2 i o

headers and trailers are processed like this only.

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What dedup-component and replicate component does?

970


List out the file extensions used in abinitio?

824


What are the components new in 2.14 compared to 1.8 and State the usage of the components?

1945


Explain what is the architecture of abinitio?

908


What are the different types of parallelism used in abinitio?

822


What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

3025


How co> operating system natively processes the data?

828


What are the differences between different versions of co-op?

750


What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

952


Explain the methods to improve performance of a graph?

847


What the difference between “look-up” file and “look is up” in abinitio?

1060


Explain how abinitio eme is segregated?

1179


What are the primary keys and foreign keys?

757


How can you force the optimizer to use a particular index?

803


Explain about ab initio’s dependency analysis?

838