Page 1 of 1

Remove Duplicates

Posted: Tue Jun 13, 2017 11:01 pm
by phanikumar
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

Posted: Wed Jun 14, 2017 6:47 am
by anudeepdasari001
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.