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

which cache supports connected & un connected Lookup

1 Answers   Wipro,

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

What are the steps required to kill the job in Datastage?

0 Answers  

which unix commands mostly used in datastage

3 Answers   HSBC,

What are the various kinds of containers available in datastage?

0 Answers  

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

1 Answers   TCS,

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  

What are the some differences between 7.x and 8.x version of datastage?

0 Answers  

where the log files or tables can store in DS?

2 Answers   IBM,

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

how to sort two columns in single job in datastage.

1 Answers   TCS,

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories