Search found 18 matches

Go to advanced search

by pranay
Thu Jun 12, 2008 12:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: executing a set of sql queries in a job
Replies: 24
Views: 10775

Place all these querries in a sql procedure and call the procedure using a stored procedure stage. The job design can be like ODBC stage to Store procedire stage. ODBC stage can have a sql query to start the job. The query can be select 1 from dual. Let me know if u have any questions on this.
by pranay
Thu Jun 12, 2008 11:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: count the rows
Replies: 6
Views: 1863

use the aggregator stage with columns COL1 and count(COL1).
by pranay
Thu Aug 24, 2006 1:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inheriting a job: IPC Partition fed direct to IPC Collector
Replies: 4
Views: 1795

Re: Inheriting a job: IPC Partition fed direct to IPC Collec

The LC and LP might have been placed consequently so as to improve the performance of the job. Or might be for renaming some columns. Why don't u remove these componenets and compare the performance with the original one. I think for cases like this Trial and Error is teh best solution. Regards, Pra...

Go to advanced search