Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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?

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

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,


what are the different type of errors in datastage?

2 Answers   Wipro,


Can you explain kafka connector?

0 Answers  


Demonstrate experience in maintaining quality process standards?

0 Answers   iGate,


how can u connect the client system directly at any time?

1 Answers   IBM,






convert yyyy mm dd to dd mm yyyy?

4 Answers  


How rejected rows are managed in datastage?

0 Answers  


i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,


What is oci?

0 Answers  


LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

2 Answers   Mannar Company, ME,


What are the enhancements made in datastage 7.5 compare with 7.0?

0 Answers  


I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,






Categories