Search found 3 matches

by datastage1
Fri Aug 25, 2006 7:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: date transformation
Replies: 3
Views: 1652

date transformation

How to do date transformation if we have two different databases at the source and target?
Thanks and appreciate the helpful answers
by datastage1
Fri Aug 25, 2006 7:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Track duplicate rows in the source data
Replies: 4
Views: 2253

If you have an oracle source or any DB table then you can filter within the select statement. To find if there are any duplicate values in TABLE_B alone (if there is a primary key then there will be no duplicates) type the following: SELECT COUNT(*), COLUMN_A, COLUMN_B FROM TABLE_B GROUP BY COLUMN_...
by datastage1
Fri Aug 25, 2006 7:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error : out of memory space.
Replies: 3
Views: 1514

Error : out of memory space.

Hello all,
I am getting an error in a server job as out of memory space.what might be the problem?
Thanks