Search found 816 matches
- Thu Aug 02, 2007 1:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: lookup on null field giving warning
- Replies: 1
- Views: 1636
- Thu Aug 02, 2007 12:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle OCI Stage Performance
- Replies: 6
- Views: 2143
Oracle OCI Stage Performance
Hi all, In one of my job i am using Oracle OCI stage to pull data from the source system. I am doing a simple left outer join based on date constraints. When i am executing this SQL from TOAD it is taking 15 minutes to complete but In DataStage it is taking almost 1 hour 10 minutes. My job design is...
- Thu Jul 26, 2007 12:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DateTimestamp
- Replies: 20
- Views: 6656
- Wed Jul 25, 2007 2:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for dates/timestamps in MOdify Stage
- Replies: 13
- Views: 12219
- Wed Jul 25, 2007 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem viewing the data
- Replies: 14
- Views: 5405
- Wed Jul 25, 2007 9:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DateTimestamp
- Replies: 20
- Views: 6656
- Tue Jul 24, 2007 4:48 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DateTimestamp
- Replies: 20
- Views: 6656
- Tue Jul 24, 2007 3:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem viewing the data
- Replies: 14
- Views: 5405
- Tue Jul 24, 2007 3:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem viewing the data
- Replies: 14
- Views: 5405
- Tue Jul 24, 2007 3:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DateTimestamp
- Replies: 20
- Views: 6656
Just do some tweaking with the code:
Code: Select all
Fmt(Oconv(Iconv(InDWWORK.DW_ADJ_DATE,"DYMD[4,2,2]"),"DMDY[2,2,4]"): InDWWORK.DW_ADJ_TIME,"##/##/#### ##:##:##")
- Tue Jul 24, 2007 11:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to convert 20070625 to Date Format(mm/dd/yyyy) in PX
- Replies: 6
- Views: 2296
- Tue Jul 24, 2007 10:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: julian date
- Replies: 4
- Views: 2294
Just remove / from the code and it will work.
Code: Select all
Oconv(Iconv(Right(InLink.TheString,7), "D4JY"), "DDMY[2,2,4]")
- Tue Jul 24, 2007 10:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion error
- Replies: 11
- Views: 5229
- Tue Jul 24, 2007 9:48 am
- Forum: Site/Forum
- Topic: DSguru2B crossed 6K.
- Replies: 4
- Views: 3909
- Mon Jul 23, 2007 3:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling for dates/timestamps in MOdify Stage
- Replies: 13
- Views: 12219