Output for sort and dedupsort with NULL key?

Categories >> Software >> Data Warehouse >> Ab Initio
Suggest New Category

Question Posted / ram1234

6 Answers
29429 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Output for sort and dedupsort with NULL key?..

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

Output for sort and dedupsort with NULL key?..

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

Output for sort and dedupsort with NULL key?..

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

Output for sort and dedupsort with NULL key?..

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

Output for sort and dedupsort with NULL key?..

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

Output for sort and dedupsort with NULL key?..

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

Post New Answer