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 / prasu
In Duplicate Stages we have more number of optionscompare
to sort while removing duplicates.If you have less number
if data you can go with Sort stage to remove duolicats.If
you have large number of data go for Remove Duplicates
Stage.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Describe link sort?
How to clean the datastage repository?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the components of ascential data stage?
What is the use of datastage designer?
What are the different kinds of views available in a datastage director?
Demonstrate experience in maintaining quality process standards?
Can you highlight the main features of ibm infosphere information server?
Name the different sorting methods in datastage.
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
Which algorithm you used for your hashfile?
How to read the length of word in unix?
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 is difference between symmetric multiprocessing and massive parallel processing?
Where do you see different stages in the designer?