DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
phanikumar
Participant



Joined: 20 Sep 2011
Posts: 57
Location: INDIA
Points: 502

Post Posted: Tue Jun 13, 2017 11:01 pm Reply with quote    Back to top    

DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi All,

Is it possible to remove duplicates by Ignoring case sensitive in Data Stage..

Example:

Name:

Steve
STEVE

Can I remove duplicates on the above..

Regards
Kumar
anudeepdasari001
Participant



Joined: 14 Dec 2015
Posts: 42
Location: Arizona
Points: 354

Post Posted: Wed Jun 14, 2017 6:47 am Reply with quote    Back to top    

Phani,

There is a property in Remove duplicate stage called Case Sensitive, Set that property to false,

By making that property to false,it treats steve and STEVE as same.That should serve your purpose.

_________________
anudpETL
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours