Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how to get the unique records on multiple columns by using
sequential file stage only

Answers were Sorted based on User's Feedback



how to get the unique records on multiple columns by using sequential file stage only..

Answer / chandu

in sequential file there is one option is there i.e
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.

Is This Answer Correct ?    7 Yes 0 No

how to get the unique records on multiple columns by using sequential file stage only..

Answer / subhash

SORT -u file_name.txt
or
SORT|UNIQ file_name.txt

Is This Answer Correct ?    3 Yes 0 No

how to get the unique records on multiple columns by using sequential file stage only..

Answer / todearhari

Just a small correction to Above Answer ,First we need to sort the Data then use the Uniq then only you will get Complete uniq records as uniq compares line by line.

Command:
Sort |Uniq

Is This Answer Correct ?    2 Yes 0 No

Post New Answer



More Data Stage Interview Questions

Explain entity, attribute and relationship in datastage?

0 Answers  


What is difference between server jobs & parallel jobs?

0 Answers  


I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,


how will u design file watch jobs?

2 Answers  


what is repositery?

0 Answers   IBM,






What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  


How will you move hashed file from one location to another location?

0 Answers   NTT Data,


How to initialize environment variables?

4 Answers   Infosys,


Does datastage support slowly changing dimensions ?

0 Answers  


CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,


i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  


how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,






Categories