Hi This is Vijay,

How can your remove the duplicates in sequential File?

Answer Posted / prasu

Hi Manoj,

Where u will give the Distinct Keyword...This is not a
table ..it is file...

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you remove duplicate values in datastage?

625


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

347


AGGREGATOR default datatype

931


What could be a data source system?

575


What are the different plug-ins stages used in your projects?

623






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

1463


Can we use target hash file as a lookup ?

2814


On which Dimension Table you implemented SCD Type in your Project

1577


root tree will find which is server job and which is parallel job?

1445


What is the process of killing a job in datastage?

589


What is the different type of jobs in datastage?

568


How many types of sorting methods are available in datastage?

629


How a source file is populated?

614


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

727


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

772