| |
GeekInterview.com > Interview Questions > Data Warehousing > Abinitio
| Print | |
Question: Output for sort and dedup sort with null key
Answer: I have file containing 5 unique rows and I am passing them through SORT component using null key and and passing output of SORT to Dedup sort. What will happen, what will be the output. |
| November 11, 2008 08:27:34 |
#2 |
| geetha1223 |
Member Since: November 2008 Total Comments: 1 |
RE: Output for sort and dedup sort with null key
|
If there is no key used in the sort component, while using the dedup sort the output depends on the keep parameter.
If its set to firt then the output would have only the first record,
if its set to last the output would have the last record,
if its set to unique_only,then there would be no records in the output file. |
| |
Back To Question | |
