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

i have a some records
eno ename acono amount
1001 suresh sbi101 12000
1001 suresh sbi101 14000
1001 is dublicata how can i remove duplicate?

Question Posted / chandrasekhar.dasg

Answers were Sorted based on User's Feedback



i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 ..

Answer / prasad

by using sort stage also, goto properties tab select alllow
duplicates=false.

Is This Answer Correct ?    4 Yes 0 No

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 ..

Answer / venu

You can use Remove Duplicate Stage and select key
as 'eno'... now the out will be without duplicates...

Is This Answer Correct ?    2 Yes 0 No

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 ..

Answer / narayana reddy

we can remove the duplicate record i.e. 1001 by
1)using remove duplicate stage by giving as key = eno
2) using sort stage enter key column=eno allow duplicates
=false.
3) by giving partition alogarithms = hash
pariion key =eno that shoud dfine in properties tab.




Regards
Narayana

Is This Answer Correct ?    1 Yes 0 No

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 ..

Answer / bharathram1234

we can use either rm_duplcte or srt stage..
but if You need any of duplicate record among all other then
u go 4 sort
and if u need last record or first record among all we go 4
rm_duplcte stage.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

How did you reconcile source with target?

2 Answers   HP,

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

project Steps,hits, Project level HArd things,Solved methods?

0 Answers   Hexaware,

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

how to define satge variables in transformer stage

2 Answers  

how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,

What is the project in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories