Hi,
How to read DISTINCT sring from flat file ?
Can any one help ? Please ?
How to read DISTINCT from flat file ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Remove Duplicates requires sorted input. In increasing order of inefficiency, try the following techniques.
- Sort within DataStage, specifying "Unique"
Filter through sort -u
Remove Duplicates stage
Access through ODBC and specify DISTINCT in the SQL statement.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.