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

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?

Question Posted / prasad

4 Answers
8948 Views
I also Faced
E-Mail Answers

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

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3814

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1469

which r the connectors used in san?

2232

What is difference between symmetric multiprocessing and massive parallel processing?

1200

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

1172

Define APT_CONFIG in Datastage?

1135

What is a datastage job?

1059

What is datastage?

1133

How to find value from a column in a dataset?

2256

How rejected rows are managed in datastage?

1578

how to add a new records into source?

2058

How to read the length of word in unix?

1437

How many types of hash files are there?

1238

How to implement complex jobs in data stage?

1163

How you can fix the truncated data error in datastage?

1889