| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: Remove duplicates using transformer
Answer: how do you remove duplicates using transformer stage in datastage |
| July 07, 2008 02:42:30 |
#2 |
| umamahesh.ds |
Member Since: July 2008 Total Comments: 2 |
RE: Remove duplicates using transformer
|
In that Time double click on transformer stage---> Go to Stage properties(its having in hedder line first icon) ---->double click on stage properties --->Go to inputs ---->go to partitioning---->select one partition technick(with out auto)--->now enable perform sort--->click on perfom sort----> now enable unique---->click on that and we can take required colum name. now out put will come unique values so here duplicats will be removed.
|
| |
Back To Question | |
