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
How do you remove duplicate values in datastage?
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
AGGREGATOR default datatype
What could be a data source system?
What are the different plug-ins stages used in your projects?
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
Can we use target hash file as a lookup ?
On which Dimension Table you implemented SCD Type in your Project
root tree will find which is server job and which is parallel job?
What is the process of killing a job in datastage?
What is the different type of jobs in datastage?
How many types of sorting methods are available in datastage?
How a source file is populated?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
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