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
Answer / prasad
by using sort stage also, goto properties tab select alllow
|Is This Answer Correct ?||4 Yes||0 No|
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|
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
3) by giving partition alogarithms = hash
pariion key =eno that shoud dfine in properties tab.
|Is This Answer Correct ?||1 Yes||0 No|
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
|Is This Answer Correct ?||0 Yes||0 No|
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,
what are the different type of errors in datastage?
Can you explain kafka connector?
Demonstrate experience in maintaining quality process standards?
how can u connect the client system directly at any time?
convert yyyy mm dd to dd mm yyyy?
How rejected rows are managed in datastage?
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?
What is oci?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
What are the enhancements made in datastage 7.5 compare with 7.0?
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?