Answer Detail: RE: How do you eliminate duplicate rows?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Print |

Question: How do you eliminate duplicate rows?

August 08, 2005 20:30:49	#4
Mujeebur	Member Since: Visitor Total Comments: N/A
RE: How do you eliminate duplicate rows?
removal of duplicates done in two ways: 1. Use "Duplicate Data Removal" stage or 2. use group by on all the columns used in select , duplicates will go away.