Search found 16 matches
- Mon Feb 28, 2005 3:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Perfromance Issues
- Replies: 7
- Views: 3682
Perfromance Issues
Job extracts data from Orcale tables compares the data and loads it to a flat file. One of the queries that is executed against the database is going to the hanging state. The query fired against the database is like SELECT DISTINCT COL1,COL2,COL3 FROM tab1 WHERE EXISTS ( SELECT 'X' FROM TAB2 WHERE ...