Output for sort and dedupsort with NULL key?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / zealously
Output of sort --> same as input file
output of dup port--> out port (First Record) dup port(Rest of record) when keep=First
out port (Last Record) dup port(Rest of record) when keep=Last
out port (Zero Record) dup port(All record) when keep=Unique
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / 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 |
Answer / raju mortale
Output for Sort when pass key as {}
Ans - Sort component will does not perform any ordering on data, it will give a same input to your output.
Output for Dedup Sorted when pass key as {}
Ans- 1.If your keep parameter is first then it will give first record from input records.
2. If your keep parameter is last then it will give last record from input records.
3. If your keep parameter is unique only then it give zero records in output.
but if your input file contains only one record then it give one record in output.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ar
It will treat all the columns as part of key. In the key
parameter you have to mention "{}" to make it as a NULL key.
If all the column values for two consecutive records are
same, then only it will dedup or it will send all the
records to output port.
Is This Answer Correct ? | 2 Yes | 4 No |
Answer / raj
i think in the above case dedup sort will give all the
records in out put even if we sort on any of the three
fields
Is This Answer Correct ? | 6 Yes | 15 No |
What is meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?
If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.
explain checkin and checkout?
What is a rollup component?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
Explain what is the architecture of abinitio?
Mention some ways for improving performance of a graph?
How you can run a graph infinitely in ab initio?
What mpjret contains ? How to use in abinitio graph?
why Skew should always be 0 ? How to use in abinitio graph?
Explain the ab initio etl tool in high level?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?