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 / prasad

by using sort stage also, goto properties tab select alllow
duplicates=false.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the flow of loading data into fact & dimensional tables?

585


What is usage analysis in datastage?

802


Name the different sorting methods in datastage.

603


State the difference between an operational datastage and a data warehouse?

598


How complex jobs are implemented in datstage to improve performance?

584






What is the difference between the local container and shared container?

638


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

2981


What are sequencers?

606


What are the processing stages?

633


Can we use target hash file as a lookup ?

2806


Distinguish between informatica & datastage. Which one would you choose and why?

574


Why do you need stage variables?

651


What is a merge in datastage?

758


What is the command line function to import and export the ds jobs?

670


What is ds designer?

641