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
What all the types of jobs you developed?
How and where you used hash file?
Why we use surrogate key?
what is the use of surogate key in datastage
What is the difference between odbc and drs stage?
how many rows sorted in sort stage by default in server jobs
How a source file is populated?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is process model?
What is ibm datastage flow designer?
Notification Activity
client know skid info?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How to implement complex jobs in data stage?