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 / swati

In Remove Duplicate stage you will get only unique records.

In sort Stage you will get both unique and duplicate records based on key change column.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a merge?

662


Can you highlight the main features of ibm infosphere information server?

631


What is the roundrobin collector?

635


Lookup constraints

833


What a datastage macro?

625






Name the command line functions to import and export the DS jobs?

697


Define Data Stage?

631


What is apt_config in datastage?

697


Nls stands for what in datastage?

722


What is usage analysis in datastage?

805


sed,awk,head

960


How one source columns or rows to be loaded in to two different tables?

654


How to reverse the string using unix?

2792


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1461


Difference between data warehousing and olap?

644