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

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,

How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

What is audit table?

1 Answers  

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

Can you define merge?

0 Answers  

What are the difference types of stages?

0 Answers  

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,

What is the purpose of pivot stage?

0 Answers  

What are the job parameters?

0 Answers  

Define ds designer?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories