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
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Could anyone give brief explanation bout datastage admin
Difference between ‘validated ok’ and ‘compiled’ in data stage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Explain entity, attribute and relationship in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
Explain the importance of surrogate key in data warehousing?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How to read the length of word in unix?
What are the various kinds of the hash file?
What is use Array size in datastage
What are the different kinds of views available in a datastage director?
What is difference between server jobs & parallel jobs?
What is the differentiate between data file and descriptor file?
What are the steps required to kill the job in Datastage?