Hi This is Vijay,

How can your remove the duplicates in sequential File?

Answer Posted / manoj

By using "DISTINCT" key word can remove all the duplicates
in the record or file .......

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between an operational datastage and a data warehouse?

734


What are the types of views in datastage director?

1396


What are the steps required to kill the job in Datastage?

790


How do you import and export the datastage jobs?

826


Differentiate between odbc and drs stage?

697






What is ibm datastage flow designer?

787


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2934


How many types of hash files are there?

706


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

443


Explain the datastage parallel extender (px) or enterprise edition (ee)?

850


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

732


Define Routines and their types?

723


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1569


What is the difference between passive stage and active stage?

957


What are datastage sequences?

777