Remove Duplicates

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
phanikumar
Participant
Posts: 60
Joined: Tue Sep 20, 2011 10:44 pm
Location: INDIA

Remove Duplicates

Post 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
anudeepdasari001
Participant
Posts: 58
Joined: Mon Dec 14, 2015 3:16 pm
Location: Arizona

Post 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.
anudpETL
Post Reply