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 read multiple files using a single datastage job if files have the same metadata?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
State the difference between an operational datastage and a data warehouse?
What is the differentiate between data file and descriptor file?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the functionalities of link partitioner?
Name the different sorting methods in datastage.
what is the use of materialized view?
What is quality stage?
How do you start developing a datastage project?
What are routines in datastage? Enlist various types of routines.
What is ibm datastage?
Explain the importance of surrogate key in data warehousing?
How do y read Sequential file from job control?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?