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
What is a deadlock and how it occurs?
What are “business rules” in ab initio business rules environment (bre)?
What do you understand by overflow errors?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
What are the differences between different versions of co-op?
what is the output when -1 is put in select_expr of FBE?
Have you ever encountered an error called “depth not equal”?
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
Code check-in and check-out commands in AbInitio
List out some of the air commands used in abintio?
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?
Explain the difference between the truncate and delete commands?
What does it mean by the term 'sort component'?
How can I run the 2 gui merge files?
How does the bre work with the co>operating system?
