Null key in scan and dedup

If we give NULL key in scan component what will be the output and in dedup with keep parameter as unique?

Showing Answers 1 - 6 of 6 Answers


  • Dec 17th, 2014

When we give {} as key in scan, it gives all of the records in output and when we give {} in dedup, output depends on the keep parameter..

  Was this answer useful?  Yes


  • Dec 20th, 2014

If you keep {} or any value it sends all the records into the output
Where as in dedup if you keep key as {} and keep unique as parameter then no records will be sent
it treat as single group and no unique values will be fetched
Someone can correct me if im wrong

  Was this answer useful?  Yes


  • Feb 16th, 2015

In case of {} key in scan it will give all the records in case of dedup if you keep it as first it will give first record if you keep it as last it will give last record in case of unique only it will give no records.

  Was this answer useful?  Yes


  • Feb 17th, 2015

Can you pls let me know are you guys aware of abinitio ?if key is NULL what is the meaning of SORT?

  Was this answer useful?  Yes


  • Sep 6th, 2018

If key is {} in sort then Data will not get sort. It gives as it is data which is received from in port

  Was this answer useful?  Yes

Amaan Sajid Ansari

  • Nov 14th, 2018

For unique only, the output for Dedup will be 0 records. While if you keep it to first or last it will be first or last record of each partition respectively.. While in case of scam it will treat the entire base as one group, or divide the entire base = Number of parttions if the file is partitioned.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions