Interested to Buy Any Domain ? << Click Here >> for more details...
Output for sort and dedupsort with NULL key?
- 6 Answers
- 29680 Views
- I also Faced
- E-Mail Answers
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 a data processing cycle and what is its significance?
What is the diff between abinitiorc and .abinitiorc files ?
) Diff.between Output index and Output indexes?
What is the difference between look-up file and look-up, with a relevant example?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
How you can run a component for certain conditions ?
what i the difference between the flows of 3 paralellisms
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
Difference between public and private projects and how to make private to public?
how to calculate EME version using unix ?
Describe the grant/revoke ddl facility and how it is implemented?
Mention some file extensions which are used in abinitio?
Teradata 
