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
What is ds designer?
What is the purpose of pivot stage and types of containers in datastage
Explain the importance of surrogate key in data warehousing?
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
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the differences between datastage and informatica?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Differentiate between datastage and informatica?
What is the command line function to import and export the ds jobs?
What are the components of datastage?
Can you explain link buffering?
What is active and passive stage?
How and where you used hash file?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the purpose of pivot stage?