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

What is Cleanup Resources and when do you use it?

2 Answers  

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  

How to remove blank spaces from data?

3 Answers  

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

what is the unix script to run the job? Please mention commands which we use often?

3 Answers   TCS,

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

How to reverse the string using SQL?

0 Answers   CTS,

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,

what is mapping lookup

1 Answers  

How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.

5 Answers  

For more Data Stage Interview Questions Click Here
Categories