Answer Posted / koel
Whenever we sort a set of records with NULL key
automatically it consider the records as one group & data
will be as per the input serial number and will be sorted
according to that.But dedup will again cosider the records
as one group & output will be the first record
automatically.
e.g.input records:1,XYZ,100;
2,ABC,700;
5,JJJ,400;
7,KKK,500;
using NULL key sort component will give output as:
1,XYZ,100;
2,ABC,700;
5,JJJ,400;
7,KKK,500;
Dedup sort will give output as:
1,XYZ,100;
| Is This Answer Correct ? | 24 Yes | 7 No |
Post New Answer View All Answers
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
What is is a data flow graph?
Can you explain data flow graph with an example?
What does it mean by the term 'sort component'?
How many components in your most complicated graph?
What do you know about abinitio?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
What the difference between “look-up” file and “look is up” in abinitio?
What is a partition and what are the different types of partition components in abinitio?
explain checkin and checkout?
What is sandbox?
what is the output when -1 is put in select_expr of FBE?
List out the file extensions used in abinitio?
How do you improve the performance of a graph?
What is the difference between rollup and scan?