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 / data master
Sort Stage do Sorting of data and performing Remove
Duplicate records, which will slow the performance of job
(Hence it is better to sort data at database level).
If the data is already sorted than use the Remove Duplicate
Stage to remove duplicate records, Which will give better
performance of job than above situation.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
client know skid info?
Define Routines and their types?
What are the types of containers?
how many rows sorted in sort stage by default in server jobs
On which Dimension Table you implemented SCD Type in your Project
What are data elements?
What are the different types of lookups in datastage?
Explain ibm infosphere information server and highlight its main features?
Explain entity, attribute and relationship in datastage?
in oracle target stage when we use load option and when we use upsert option?
How many types of stage?
What is the method of removing duplicates, without the remove duplicate stage?
How many types of sorting methods are available in datastage?
What is job control?
Nls stands for what in datastage?