Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

1)How to Duplicate Records Delete in Sequential file?

Question Posted / hari

Answers were Sorted based on User's Feedback



1)How to Duplicate Records Delete in Sequential file?..

Answer / naga

connect sequential file to dataset and use partition
technique and perform sort and select unique

Is This Answer Correct ?    19 Yes 6 No

1)How to Duplicate Records Delete in Sequential file?..

Answer / vinod upputuri

In the sequential File stage there is a option called filter.
there we can use UNIX command.

syntax for Remove duplicate: uniq or sort -u

Is This Answer Correct ?    11 Yes 1 No

1)How to Duplicate Records Delete in Sequential file?..

Answer / subhash

small correction to Vinod answer,
If we use UNIQ, it will remove duplicate if they are
consecutive only..
so, better to use
sort -u
or
sort file_name | uniq

Is This Answer Correct ?    9 Yes 0 No

1)How to Duplicate Records Delete in Sequential file?..

Answer / topper

Select the data set and press delete..

Is This Answer Correct ?    0 Yes 15 No

Post New Answer

More Data Stage Interview Questions

Is it possible to query a hash file?

0 Answers   IBM,

What are the benefits of datastage?

0 Answers  

how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,

what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?

2 Answers  

Can you define merge?

0 Answers  

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

How to display all the duplicate records from the oracle Table?

3 Answers   IBM,

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  

What is the difference between hashfile and sequential file?

0 Answers  

Explain the importance of surrogate key in data warehousing?

0 Answers  

How do you schedule or monitoring the job?

0 Answers  

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories