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 is sandbox?

708


Mention what is the syntax for m_dump in abinitio?

967


Mention what dedup-component and replicate component does?

614


You can ask about different vector functions. How to use in abinitio graph?

5028


Have you worked with packages?

655






What is a look-up?

660


What will be the skew for, input file->partition by key-> partition by round robin->output file

419


Define ramp limit in ab initio?

765


What is local and formal parameter?

768


Is data warehousing different from data mining?

631


How you can run a graph infinitely in ab initio?

778


Describe the grant/revoke ddl facility and how it is implemented?

695


What metadata importer can do in ab initio?

693


What is a local lookup?

692


What is the purpose of having stored procedures in a data-based?

565