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....
- 4 Answers
- 21978 Views
- Target, I also Faced
- E-Mail Answers
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
Differentiate between hash file and sequential file?
What is the difference between orabulk and bcp stages?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
how to delete one row in target dataset
Can you explain kafka connector?
What is ibm datastage?
What are the different types of lookups in datastage?
What are constraints and derivations?
what is the use of materialized view?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
how to write server Routine coding?
What are the repository tables in datastage?
Define project in datastage?
Differentiate between operational datastage (ods) and data warehouse?
