Order by key columns and date, and use the Remove Duplicates stage. You can choose to keep the first or last row, which would be the same a min or max date.
HTH,
Gaby
Search found 29 matches
- Wed Sep 17, 2008 10:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator stage
- Replies: 5
- Views: 3644
- Fri Sep 12, 2008 7:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trap Duplicate record
- Replies: 7
- Views: 3432
- Fri Sep 12, 2008 7:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parallel loading with SQL loader Direct path
- Replies: 2
- Views: 2418
- Fri Sep 12, 2008 7:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Compile error
- Replies: 4
- Views: 2234
- Thu Sep 04, 2008 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to implement "Not In" function in Filter Stage
- Replies: 4
- Views: 4953
- Tue Sep 02, 2008 6:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Deadlock detected while inserting into Oracle table
- Replies: 6
- Views: 5100
- Tue Aug 19, 2008 7:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Commit frequency when using Oracle Load/Append
- Replies: 15
- Views: 11371
The ORA_UPSERT_COMMIT parameters are specific to using the Upsert option, not the Load option. When using the Load option, one temporary file is created for each partition that is running for the Oracle stage. When the job finishes running for all the source rows, then the sqlloader is called for ea...
- Mon Aug 11, 2008 12:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: generate osh
- Replies: 3
- Views: 2834
- Fri Aug 08, 2008 12:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Deadlocks
- Replies: 3
- Views: 3417
- Fri Aug 08, 2008 12:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Best approach for determining changes
- Replies: 6
- Views: 4072
- Fri Aug 08, 2008 12:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Deadlocks
- Replies: 3
- Views: 3417
- Fri Aug 08, 2008 10:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Format
- Replies: 7
- Views: 3026
- Fri Aug 08, 2008 9:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SAP BAPI stage query
- Replies: 1
- Views: 1317
- Mon Feb 27, 2006 8:29 am
- Forum:
- Topic: Reporting DataStage Operational Metadata via MetaStage
- Replies: 2
- Views: 2503
Re: Reporting DataStage Operational Metadata via MetaStage
For starters, your question is a totally different topic than the one discussed here.
On the other hand, Data Lineage / Impact Analysis and the browser are quite different from each other.
On the other hand, Data Lineage / Impact Analysis and the browser are quite different from each other.
- Thu Feb 23, 2006 7:05 am
- Forum:
- Topic: Sync between Import Category & User-Defined Category
- Replies: 4
- Views: 1883