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


Please Help Members By Posting Answers For Below Questions

AGGREGATOR default datatype

909


What are the functionalities of link partitioner?

594


What is "fatal error/rdbms code 3996" error?

645


explain about citrix scheduling tool in datastage

1785


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

594






Whats difference betweeen operational data stage (ods) and data warehouse?

645


How can we improve performance of data stage jobs?

594


What is the difference between datastage and informatica?

588


How do you start developing a datastage project?

640


How to reverse the string using SQL?

863


Differentiate between odbc and drs stage?

570


What is difference between symmetric multiprocessing and massive parallel processing?

633


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

640


Is it possible to query a hash file?

1539


What are transforms and what is the differenece between routines and transforms?

583