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 Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the sortmerge collector?
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
how to export or import the jobs in .ISX file
describe the Steps to confiure a Qlogic switch
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to reverse the string using SQL?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Can you explain tagbatch restructure operator?
Explain usage analysis in datastage?
How and where you used hash file?
What is the method of removing duplicates, without the remove duplicate stage?
What is the difference between orabulk and bcp stages?
How do y read Sequential file from job control?
I have a few records just I want to store data in to targets cycling way how?