Search found 349 matches
- Fri Mar 04, 2011 9:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: I need to implement the below logic
- Replies: 9
- Views: 6530
Hi To check the reject file, there are many ways, either you can use a execute command stage and have a unix command like cat and see if there is any output or do a link count. For job3, read the new source file (the reject file that has been renamed) and send it to transformer, in the Xfm do the da...
- Thu Mar 03, 2011 3:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: I need to implement the below logic
- Replies: 9
- Views: 6530
Ho about have 2 jobs and then looping it. Jobs 1: read source file , do the look up and reject records that do not match. Job2: Using exec command stage, rename the reject file as source file Job3: Similar to job1 , but will take the new source file and minus 1 day and apply the look up again and re...
- Fri Jun 25, 2010 6:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Accessing Active Directory information
- Replies: 6
- Views: 4012
- Thu Jun 24, 2010 8:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Accessing Active Directory information
- Replies: 6
- Views: 4012
- Mon Oct 08, 2007 5:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup inter dependency
- Replies: 5
- Views: 3228
- Mon Oct 08, 2007 5:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup inter dependency
- Replies: 5
- Views: 3228
Lookup inter dependency
Hi,
Can we have multiple reference look ups where lookup1 result can be used in look up2 in the same transformer?
i.e result of look up1 is the key for lookup2
Thanks,
Can we have multiple reference look ups where lookup1 result can be used in look up2 in the same transformer?
i.e result of look up1 is the key for lookup2
Thanks,
- Mon Oct 08, 2007 1:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reusable ODBC Lookups.
- Replies: 6
- Views: 3595
- Thu Apr 12, 2007 10:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse data
- Replies: 7
- Views: 3729
Hi, I have used the Field function, my source column has 3 values delimited by '-' and I needed 3 output columns , the following are the derivations for the 3 output columns, SourceCol=201-232-9090 Output Col1=201 ---->Field(SourceCol,'-',1) Output Col2=232---->Field(SourceCol,'-',2) Output Col3=909...
- Thu Apr 12, 2007 9:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse data
- Replies: 7
- Views: 3729
- Thu Apr 12, 2007 9:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse data
- Replies: 7
- Views: 3729
- Thu Apr 12, 2007 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parse data
- Replies: 7
- Views: 3729
Parse data
Hi, I am reading from a table and one of the columns has the following sample data, I need to parse the data and extract 3 fields , the delimiter is '-' Source: 205-51-510203 Required Output: 205 51 510203 Source: 201-1-10001 Required Output: 201 1 10001 Source: 202-14 Required Output: 202 14 Source...
- Thu Mar 15, 2007 6:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ABAP Extract GUI
- Replies: 6
- Views: 3431
- Mon Mar 12, 2007 2:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 1403 Oracle Error -Upsert
- Replies: 9
- Views: 13674
- Mon Mar 12, 2007 1:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: 1403 Oracle Error -Upsert
- Replies: 9
- Views: 13674
1403 Oracle Error -Upsert
Hi, When I run a job which reads from SQL and loads into Oracle table using Oracle Ent Stage, I get the "sqlcode:1403 " error. When I take the Update stmt from the stage and execute it in Toad it works fine ! I did try to change the 'Update Else Insert' option to 'Insert else Update' but i...
- Thu Mar 08, 2007 11:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Insert Null values into Oracle date column
- Replies: 12
- Views: 10186