Interested to Buy Any Domain ? << Click Here >> for more details...
Output for sort and dedupsort with NULL key?
- 6 Answers
- 29606 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 the difference between ab_work_dir and .work
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
What is the max core of a component?
How to create repository in abinitio for stand alone system(local nt)?
) Diff.between Output index and Output indexes?
What is use of creating a save files? How to use in abinitio graph?
1 Answers Cognizant, IBM, Intellego, TCL,
How to Create Surrogate Key using Ab Initio?
How would you find out whether a sql query is using the indices you expect?
what are kinds of layouts does ab initio supports ?
How to move or copy the project parameter or project object to my sandbox?
Graph was failed how it is achived ? send answer with phone number? i want speak with directly who is intrest on abinitio?
When we should use 'jobid' for commit table (Output table component??
Teradata 
