Search found 102 matches
- Thu Nov 03, 2011 5:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: split a column value and create separate rows for each slit
- Replies: 5
- Views: 3824
Hi all, Thanks for your suggestions. My colleague developed the solution. First we add (sparcv9) to the beginning of 2nd record, store in a flat file, add a index column indicating CPUs belonging to Computer 1/2/3 etc. Second we read from the flat file with (sparcv9) as the delimiter. Rebuild the in...
- Wed Nov 02, 2011 6:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: split a column value and create separate rows for each slit
- Replies: 5
- Views: 3824
- Wed Nov 02, 2011 4:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: split a column value and create separate rows for each slit
- Replies: 5
- Views: 3824
split a column value and create separate rows for each slit
Hi All, Source is from a SQL Server. Target is an Oracle table. I have a requirement where the input is: Computerid=1,Name="Solaris",Value="CPU1 1156MHz (sparcv9) CPU2 1156Mhz . . CPU32 1156MHz" I have to ouput this to: SurrKey, Computerid=1,Name="Solaris",Value="C...
- Tue Sep 26, 2006 10:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find row that causes error
- Replies: 13
- Views: 9048
i have never worked with SQL Server... in Oracle i manually insert a row using TOAD taking a row from the flat file ... if you can insert one row you can insert pretty much all of them.... if problem persists, you may divide your file into smaller parts and get the problem rows...or get an idea whic...
- Mon Sep 11, 2006 1:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Delimiter for field "COL_NAME" not found;
- Replies: 18
- Views: 18144
- Fri Aug 11, 2006 1:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Migration from Abinitio to Datastage
- Replies: 13
- Views: 12603
- Wed Jan 25, 2006 3:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-00060: deadlock detected
- Replies: 11
- Views: 10080
I think what Ray is telling is true. I had a similar problem in one of my jobs. I discussed the deadlock issue with my DBA and team members. We found that i was updating the same row in parallel processes. Once for Insert and once for Update. I think i had selected the Insert and Update option. This...
- Mon Nov 14, 2005 11:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what stage to use?
- Replies: 14
- Views: 8318
Hi all, I got the job to run. i have not done performance testing yet as i dont have a big enough test file. In the Oracle stage, in the query i say: nvl(to_number(substr(ZONE_ID,6,4),'9999'),'9999') as ZONE_CODE ZONE_ID is varchar(20). But actual value is like 1234.5678. Column ZONE_CODE is defined...
- Thu Nov 03, 2005 10:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what stage to use?
- Replies: 14
- Views: 8318
Yes. so performance is of vital importance.... also i will selecting from a load table and inserting into a partitioned table... already there are problems with sub-partitions...it seems there is a bug with Oracle 9i ver 9.2.0.4.0 if you create subpartitions, then the data dictionary gets corrupted....
- Wed Nov 02, 2005 11:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what stage to use?
- Replies: 14
- Views: 8318
- Mon Oct 31, 2005 1:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what stage to use?
- Replies: 14
- Views: 8318
Thanks for the suggestions. Here are more details. The source will be an Oracle load table with a max of about 25 million records. The datatype is string, Varchar2(20), to be exact. Its basically 2 ids in 1 column. Target is also an Oracle table.But the columns all have their meaningful, respective,...
- Fri Oct 28, 2005 11:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what stage to use?
- Replies: 14
- Views: 8318
- Fri Oct 28, 2005 10:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: what stage to use?
- Replies: 14
- Views: 8318
what stage to use?
Hi All,
My requirement is this.
Split a column value , value1.value2,
to two separate columns containing value1 and value2.
e.x. Input col1=1234.5678 --> Output col1 = 1234 and Output col2=5678
What stage do i use other than the transformer?
DS ver = 7.5 EE(PX)
Thanks in advance
jay
My requirement is this.
Split a column value , value1.value2,
to two separate columns containing value1 and value2.
e.x. Input col1=1234.5678 --> Output col1 = 1234 and Output col2=5678
What stage do i use other than the transformer?
DS ver = 7.5 EE(PX)
Thanks in advance
jay
- Fri Aug 26, 2005 2:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle parallel job stuck
- Replies: 17
- Views: 9259
- Tue Aug 23, 2005 10:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential file error
- Replies: 2
- Views: 1799