Search found 27 matches
- Mon Feb 22, 2010 3:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer stage function
- Replies: 9
- Views: 4091
- Tue Jan 27, 2009 4:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: OCI Stage - Issue with reading decimal values
- Replies: 11
- Views: 4983
- Wed Dec 10, 2008 7:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Stage rejects records
- Replies: 7
- Views: 3765
- Mon Oct 27, 2008 12:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Capture SQL Error Codes when loading is failed
- Replies: 2
- Views: 1577
- Thu Oct 16, 2008 12:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error
- Replies: 2
- Views: 1640
- Thu Jun 05, 2008 5:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to insert unix new line in between the single records?
- Replies: 1
- Views: 1465
How to insert unix new line in between the single records?
Each record having length of 1800.. While I am loading into the file ,I need to split these records into three.. Basically I need to insert unix new line after 600 length.. the second and third records 600 column defintion(column length) is different.. How can i load the single record into three row...
- Thu Jan 31, 2008 2:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Aggregator and run time propagation
- Replies: 1
- Views: 1642
Aggregator and run time propagation
I have some doubts on using run time column propagation in Aggregator stage.For example i am reading the data from file and loading into the sequential file through transformer and aggregator stage. If i am using run time column propagation option in other processing stage ,it will work. My curiosit...
- Mon Jan 14, 2008 1:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sparse look-up doubt
- Replies: 4
- Views: 2742
the issues are resolved.. first we asked DBA to increase the size of the table.. then we loaded the records into the table.. we created the index on the table.. This took less amount of time (App 2 hours).. Before that we created index on the table and tried inserting the records (290 million) into ...
- Tue Jan 08, 2008 12:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sparse look-up doubt
- Replies: 4
- Views: 2742
Sparse look-up doubt
there is some 290 million records in temp table. There is no primary key and index on this table.Right now i am using this table as look up. I used this table as sparse look-up in ETL job,but the datastage job is still running(More than 15 hours).. One of my friend is telling this is because of the ...
- Thu Jan 03, 2008 4:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle many records in datasets?
- Replies: 3
- Views: 1880
- Thu Jan 03, 2008 2:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle many records in datasets?
- Replies: 3
- Views: 1880
How to handle many records in datasets?
I am extracting data from two views based on key column values. The thing is both of the views having more than 100 million records.I am joining the view based on some key columns which is producing some million records. The source is oracle table(40000 records) and i am pulling the records from the...
- Mon Dec 17, 2007 5:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to load into a Table from a dataset.............
- Replies: 8
- Views: 3095
- Tue Nov 27, 2007 12:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: compiling all jobs
- Replies: 10
- Views: 3819
- Tue Nov 27, 2007 12:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: some look up issue
- Replies: 4
- Views: 2024
- Mon Nov 26, 2007 6:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Catch the last record in Stage Variable
- Replies: 5
- Views: 3368