How to remove duplicates in transformer stage? in parallel
mode
Answer Posted / santhosh
go to transformer stage properties->input->define any kind of partition over there and enable perform sort check box....
n also define the particular column need to be sorted..
it gives the sorted column out view...
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the different types of lookups in datastage?
What is the difference between operational data stage (ods) and data warehouse?
How to reverse the string using unix?
Define Data Stage?
State the difference between an operational datastage and a data warehouse?
EXPLAIN SCD
What are the important features of datastage?
What are the functionalities of link partitioner and link collector?
How will you move hashed file from one location to another location?
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
Where do the datastage jobs get stored?
Which algorithm you used for your hashfile?
What is ds designer?
how to add a new records into source?