Search found 150 matches
- Wed Jul 22, 2009 12:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Parameters from a file
- Replies: 6
- Views: 2988
- Mon Jul 20, 2009 12:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS job Monitor - Start Time changes randomly - very slow per
- Replies: 1
- Views: 930
DS job Monitor - Start Time changes randomly - very slow per
Hi (DS.7.5.2, Oracle 10g) I have a server job, and i was running it with very limited amount of data (10000 records). The job was running good last friday, but today morning when i ran it the job was very slow, less than 1 row per second. Also i was monitoring the job using the job monitor option av...
- Thu Jul 09, 2009 1:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hi Performance job design
- Replies: 5
- Views: 2906
Hi jcthornton Thank you so much. Your suggestions were very useful. 1)What do you do with Update records? This really made me think. I will move the targte look up to the begining, so i will be pulling and processing only few data. Also we are going to add creationdate and updatedate to the source, ...
- Thu Jul 09, 2009 10:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hi Performance job design
- Replies: 5
- Views: 2906
Hi Performance job design
Hi I have a requirement, I need to create jobs to populate table (insert). here is the table detail. The source table has nearly 50 columns. and the target table is something like this, col1_pk, col2, col3_fk, col4_fk.... col59. I have indicated the primary key and foreign key with PK and FK. The ta...
- Mon Jun 29, 2009 2:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp Conversion
- Replies: 9
- Views: 7485
- Mon Jun 29, 2009 2:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise Load-Append - Not inserting in Parallel
- Replies: 14
- Views: 7593
- Mon Jun 29, 2009 1:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise Load-Append - Not inserting in Parallel
- Replies: 14
- Views: 7593
- Mon Jun 29, 2009 1:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Parameter from table
- Replies: 16
- Views: 5028
Passing Parameter from table
Hi I would like to know, if there is a way to pass a value from a table as parameter. For example we use sequence as the primary key so for the first time if the sequence is 1, 2, 3....100. Then the next time it should start from 101, 102, 103, ... etc. We have a surrogate_key table where we store t...
- Fri Jun 19, 2009 2:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error - Job Aborts
- Replies: 8
- Views: 6183
- Fri Jun 19, 2009 2:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error - Job Aborts
- Replies: 8
- Views: 6183
- Fri Jun 19, 2009 2:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error - Job Aborts
- Replies: 8
- Views: 6183
- Fri Jun 19, 2009 2:03 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error - Job Aborts
- Replies: 8
- Views: 6183
this is what i have in that: Pin%%V0S84P10.Column%%13 = ( IF Pin%%V0S84P1.Column%%31 = 'SENT7' THEN FIX(((Pin%%V0S84P1.Column%%14 + Pin%%V0S84P1.Column%%5 + Pin%%V0S84P1.Column%%7 + Pin%%V0S84P1.Column%%6) * -1), 4) ELSE IF Pin%%V0S84P1.Column%%31 = 'SENT8' THEN FIX((Pin%%V0S84P1.Column%%14 + Pin%%V...
- Fri Jun 19, 2009 1:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error - Job Aborts
- Replies: 8
- Views: 6183
- Fri Jun 19, 2009 1:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error - Job Aborts
- Replies: 8
- Views: 6183
Phantom Error - Job Aborts
Hi Im getting a warning message. It reads: DataStage Job 2205 Phantom 218 Program "JOB.213807619.DT.1483139043.TRANS2": Line 302, Improper data type. Attempting to Cleanup after ABORT raised in stage LoanStgBKLoanTransSENT..xfm_SENT_logic DataStage Phantom Aborting with @ABORT.CODE = 3 i t...
- Wed Jun 10, 2009 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NLS Warning message
- Replies: 5
- Views: 2984