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 rollup component?
How do you add default rules in transformer?
Code check-in and check-out commands in AbInitio
Do you know what a local lookup is?
What are the kinds of layouts does ab initio supports?
How to move or copy the project parameter or project object to my sandbox?
What parallelisms does Abinitio support?
What are the operations that support avoiding duplicate record?
Explain about ab initio’s dependency analysis?
What is brodcasting and replicate?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
How you can run a graph infinitely in ab initio?
Is data warehousing different from data mining?
What dedup-component and replicate component does?
How scientific data processing is different from commercial data processing?
