Search found 66 matches
- Mon Nov 09, 2009 8:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Sort in conjunction with Oracle Sort
- Replies: 1
- Views: 1676
Datastage Sort in conjunction with Oracle Sort
We are using Oracle read parallesim in datastage to run the same query on multiple nodes..Later we have to sort the data to remove dups.Is it better perform if we do Oracle Sort and Again Datastage Sort or just do datastage Sort? If the data is sorted in oracle before it goes to Datastage Sort,Is da...
- Mon Oct 19, 2009 9:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sparse LookUp Requirement
- Replies: 1
- Views: 1328
Sparse LookUp Requirement
Hello, I want to know where do we use Sparse Lookup exactly. We are using Joins right now and want to replace with Sparse if the rows from Input are less compared to Lookup dataset. I dont know the exact ratio between Input/Reference. Is the sparse lookup good with 1 rows(input):20 rows(referenceLoo...
- Mon Sep 21, 2009 7:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: delete records in a dataset based on a key
- Replies: 2
- Views: 1699
delete records in a dataset based on a key
Is there a way to delete specific records from a dataset? I didnot want to delete whole dataset using orchadmin utility. any help is appreciated.
- Thu Jan 15, 2009 12:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracl Log creation in unix server
- Replies: 0
- Views: 860
Oracl Log creation in unix server
Hello,
I just want to know how the log files create for any job that we run through script or manually. It creates following way. How does it get 1286384 and 380289 in this log name ora.*.*.0.log. Please help me
LOG=ora.1286384.380289.0.log
I just want to know how the log files create for any job that we run through script or manually. It creates following way. How does it get 1286384 and 380289 in this log name ora.*.*.0.log. Please help me
LOG=ora.1286384.380289.0.log
- Thu Aug 28, 2008 7:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field in data file exceeds maximum length)
- Replies: 1
- Views: 2150
Field in data file exceeds maximum length)
I am trying to load an oracle table through datastage Enterprise. It uses SQL loader to load this table from a pipe generated control file. I have a field which is rejecting that record which is description, currently it is varchar2 (1000), the characters are no way near hitting 1000 characters, but...
- Thu Jun 19, 2008 6:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: code help
- Replies: 5
- Views: 2929
- Thu Jun 19, 2008 3:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: code help
- Replies: 5
- Views: 2929
- Thu Jun 19, 2008 3:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: code help
- Replies: 5
- Views: 2929
- Thu Jun 19, 2008 2:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: code help
- Replies: 5
- Views: 2929
code help
All, I need your help on a design,here is the sample data of a file. I need to get the output as shown below. Not sure how to get this result. I could not find out a way to do it datastage. Can you please guide me? Source key,Field,Start_dt,End_Dt 1234,ABCD,1/1/2000,1/1/2001 1234,ABCD,1/1/2001,1/1/2...
- Thu Apr 17, 2008 6:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: generate multiple rows
- Replies: 2
- Views: 1402
generate multiple rows
I am stuck on a problem here.. I have a source table with year-month column along with other fields. I have to generate date data for given month of source table. Ex: 2004-03 in source table, i have to populate 2004-03-01,2004-03-02,....2004-03-30 etc. along with other columns. Can we implement this...
- Tue Aug 28, 2007 12:47 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Mod 10 Check Routine
- Replies: 9
- Views: 3858
- Tue Aug 28, 2007 12:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Mod 10 Check Routine
- Replies: 9
- Views: 3858
Mod 10 Check Routine
Does any one has mod 10 check routine to validate any number?
- Fri Jun 29, 2007 12:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Weird error with parallel Informix Enterprise Native connect
- Replies: 0
- Views: 771
Weird error with parallel Informix Enterprise Native connect
I am getting this error in one parallel job. This job has one source table and one target table..no stage is in between them. I have turned on DUMP score..i am not getting any thing from dump message. I could not find out where the problem is. main_program: Could not check all operators because of p...
- Tue Jun 26, 2007 5:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Informix XPS Fast Stage Error
- Replies: 0
- Views: 1142
Informix XPS Fast Stage Error
I am using informix XPS fast stage as source and target stages. I have given proper database name and servername,still it is failing with below error. I tried to connect same table with informix client stage,it did work. Problem is happening with Informix Enterprise stage. Do i need to configure som...
- Tue Jun 26, 2007 12:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Job Metadata problem
- Replies: 3
- Views: 1376