Search found 24 matches

by Mike3000
Tue May 08, 2007 9:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle Stage and Sequential File
Replies: 8
Views: 3993

Oracle Stage and Sequential File

Here is a thing: server job consists of a standard [Oracle OCI] stage as source and [sequential file] as a target. We face an Oracle 9i DB. We select rows from a source and need to write this to the target (a sequential file). No [Transformer] stage is involved. We can view data through the source s...
by Mike3000
Mon Apr 30, 2007 8:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Best approach for unknown varied source
Replies: 19
Views: 7881

Ray is 1000% correct, just don't allow your client "to kill" you. Ray has an excellent advice about finite numbers of format and easy detection. I have the hands-on experience with the same type of "crazy" reqs. We followed the client and only in the middle of the project when mo...
by Mike3000
Mon Apr 30, 2007 8:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hash Partitioning
Replies: 3
Views: 1338

Just make sure that in J#1 you have a flag [Preserve Partitioning]=[Set]; So, in J#2 when one of the stages has an [Auto]-partitioning, it will definitely preserve the [Hash]-partitioning method used in J#1. And because you have three more stages with partitioning [Same], it will carry the [Hash]-pa...
by Mike3000
Tue Apr 24, 2007 2:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to run DS EE parallel jobs on W2K Server
Replies: 1
Views: 579

Unable to run DS EE parallel jobs on W2K Server

We created parallel jobs using DS EE 7.5 It compiles OK on W2K Server, but when we try to run or even validate those jobs, we'er getting the error : "The Job can not be run on this platform" Any ideas? or may be patches exist? If not, will it help to upgrade W2K Server to Windows 2003 Serv...
by Mike3000
Wed Mar 28, 2007 12:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Array size
Replies: 6
Views: 1875

Any ideas?
by Mike3000
Wed Mar 28, 2007 7:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Array size
Replies: 6
Views: 1875

Good morning Guys, Thank you for your thoughts. I use "Oracle OCI" stage. This is a part of Manual that i used: ------------------------------------------------ start Update action Choose one of the following options to update the target table: Insert rows without clearing. Inserts the new...
by Mike3000
Tue Mar 27, 2007 2:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Array size
Replies: 6
Views: 1875

Array size

This is from DS 7.5.1 Manual: "If using update existing or insert new rows or insert new or update existing rows for the update action, Array size must be 1. Otherwise, a warning is logged and the plug-in automatically sets it to 1." I use DS 7.5.1 on Unix with Oracle 9i DB on Unix and suc...
by Mike3000
Mon Mar 26, 2007 11:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Best way to start developing using parallel jobs
Replies: 11
Views: 2788

Thank you Guys for your answers.

So, i still can use the old functionality and as i go ,
i can gradually add a new functionality of Parallel jobs.

Could you suggest any books about Parallel Jobs or may be a
good link? It would be greatly appreciated.
by Mike3000
Mon Mar 26, 2007 10:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Best way to start developing using parallel jobs
Replies: 11
Views: 2788

Best way to start developing using parallel jobs

I have a good experience of doing development using Server jobs, but
now client wants to use DS Parallel Jobs.

Could you tell me please what is the best approach to make a smooth
transition to the DS Parallel Edition from DS Server Edition? and in
your opinion how difficult/time consuming is it?