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

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

Question Posted / repala24

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

wt is the difference between swith and filter stage

6 Answers   IBM,

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

what is executable in DataStage?

2 Answers  

What are the repository tables in datastage?

0 Answers  

Triggers,VIEW,Procedures

0 Answers   CTS,

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,

Why do we use exception activity in Datastage?

0 Answers  

how to create document in datastage?

1 Answers   Cap Gemini,

how to configure databases through datastage

2 Answers  

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,

For more Data Stage Interview Questions Click Here
Categories