Search found 42189 matches

Go to advanced search

by chulett
Fri Feb 21, 2014 2:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exadata and Balanced Optimization
Replies: 7
Views: 2817

Ha! Still just Oracle, wonder why it wouldn't be possible?
by chulett
Fri Feb 21, 2014 2:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Split the output files based on the size of the file
Replies: 7
Views: 4811

eostic wrote:In 9.1 the Sequential Stage has a size overflow feature where it will cut new sequential files as they flow over a particular size in Megabytes
Sweet!
by chulett
Fri Feb 21, 2014 2:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to add blank/empty line at the end of the file
Replies: 11
Views: 4235

anbu wrote:Add this awk command to filter option in target sequential file
by chulett
Fri Feb 21, 2014 2:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Exadata and Balanced Optimization
Replies: 7
Views: 2817

Seeing as how Exadata is an appliance that still runs the "normal" Oracle database software I would imagine the answer is yes.
by chulett
Fri Feb 21, 2014 1:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Split the output files based on the size of the file
Replies: 7
Views: 4811

I'm not aware of any mechanism built into DataStage to allow you to control the size of output files. Seems to me you'll need to continue to create the one large file and then find something in the public domain to split up the file as an 'after job' post-processing step. I did a quick search for &q...
by chulett
Fri Feb 21, 2014 11:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP Stage issue in 7.5.1
Replies: 1
Views: 1207

First step... get you in the correct forum. Done. Second, if you Reset the aborted job is a new message added to the log which says "From previous run..."? If so, post the contents. Also note that IDENT2 is an "invisible" transformer that is added to the job at runtime between tw...
by chulett
Fri Feb 21, 2014 8:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to add blank/empty line at the end of the file
Replies: 11
Views: 4235

srini.dw wrote:Before and after job commands are not in the company standards.
I love nonsensical standards. :roll:
by chulett
Thu Feb 20, 2014 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RCP dataset needs to update/delete/insert an Oracle stage
Replies: 5
Views: 2318

Perhaps this post might help.
by chulett
Thu Feb 20, 2014 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion from the UTF-8 character set to UTF-16LE warning
Replies: 7
Views: 8243

Ah... was wondering what the "LE" part of "UTF-16LE" stood for.
by chulett
Thu Feb 20, 2014 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pivoting but not sure vertical/horizontal
Replies: 2
Views: 1490

Agreed. Not a pivot but more of an aggregation / looping solution needed.
by chulett
Thu Feb 20, 2014 12:48 am
Forum: General
Topic: Datastage project location space
Replies: 4
Views: 1356

I think that may be more about the O/S you are running, from what I recall AIX imposes a limit on the number of sub-folders.
by chulett
Wed Feb 19, 2014 4:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Break operation in row wise comparison
Replies: 14
Views: 6308

Exactly! Wait... what? :shock:
by chulett
Wed Feb 19, 2014 10:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Improving performance of deletes
Replies: 9
Views: 3777

:idea: No need to ask your question again, it's right here... safe and sound.
by chulett
Wed Feb 19, 2014 9:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Break operation in row wise comparison
Replies: 14
Views: 6308

8)

It's all about readability and clarity of purpose.
by chulett
Wed Feb 19, 2014 9:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Replicating One input row to multiple rows
Replies: 12
Views: 3652

It's all documented quite nicely. Best to start there.

Go to advanced search