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?
Answer Posted / 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 |
Post New Answer View All Answers
AGGREGATOR default datatype
What are the functionalities of link partitioner?
What is "fatal error/rdbms code 3996" error?
explain about citrix scheduling tool in datastage
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Whats difference betweeen operational data stage (ods) and data warehouse?
How can we improve performance of data stage jobs?
What is the difference between datastage and informatica?
How do you start developing a datastage project?
How to reverse the string using SQL?
Differentiate between odbc and drs stage?
What is difference between symmetric multiprocessing and massive parallel processing?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Is it possible to query a hash file?
What are transforms and what is the differenece between routines and transforms?