when U have a remove dublicate option in sort stage, why we
have a remove dublicate stage in PX, thought it is
recamended to sort data before using a remove dublicate
stage. I hae been thinking this from days....
Answer Posted / phani kumar
Sort stage is used to sort the data and having option of
identifying the duplicate records with the value of Key
change column. But, to perform sort and remove duplicates is
leads to decrease the performance. So, it is preferable for
less amount of data.
Remove duplicates stage is used to get only unique records
either first occurrence or last occurrences. For large
amount of data, sorted data is required for better performance.
Correct me if iam wrong..........
Thanks and regards....
Phani kumar
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How to manage date conversion in Datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the differentiate between data file and descriptor file?
What is size of a transaction and an array means in a datastage?
Demonstrate experience in maintaining quality process standards?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
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
What are the different kinds of views available in a datastage director?
What are the different layers in the information server architecture?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Difference between server jobs & parallel jobs?
explain about citrix scheduling tool in datastage
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)
How many types of stage?
What is the difference between passive stage and active stage?