Search found 6797 matches

by DSguru2B
Mon Jun 11, 2007 10:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unknown Error LAYER = (5) ORIGIN = (3) SEVERITY = (5) ...
Replies: 3
Views: 1692

Your server might be heavily taxed at the time the job run was requested. Does the error happen over and over again, every time you try to run it? What is the server load on your system?
by DSguru2B
Mon Jun 11, 2007 8:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel job warning while using a Sequential file.
Replies: 3
Views: 818

A sequential file, can only read and write in sequential manner. That is, if a single file is being read or written to, ofcourse. Hence your error. And therefore, you need to clear the partitioning to get rid of the error.
by DSguru2B
Mon Jun 11, 2007 8:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error fetching data using Oracle Enterprise stage
Replies: 4
Views: 3122

Yes you do. This has been discussed many times before. Search on the error message.
by DSguru2B
Mon Jun 11, 2007 7:41 am
Forum:
Topic: How do you define "data lineage"
Replies: 12
Views: 6459

To me, its as simple as keeping track of all the steps applied to bring the data from point A to point B. And as Ray already put in prolific words, the source-to-target mapping document will keep track of that lineage.
by DSguru2B
Mon Jun 11, 2007 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing Leading and Trailing Unprintable/Special Characters
Replies: 6
Views: 2785

I think I posted a C routine to do this a while back. Search should be able to turn this up.
by DSguru2B
Mon Jun 11, 2007 7:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job Sequencer Aborted - Jobs left running
Replies: 1
Views: 597

What is the specification of the terminator stage. Does it send a stop request to running jobs or just aborts without stopping the running jobs? An exeption handler, will handle any exceptions raised during execution which you did not handle in your design. Control is always good. But if they are in...
by DSguru2B
Mon Jun 11, 2007 6:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rows/Sec
Replies: 13
Views: 4160

Doing a lookup against the database, directly, is your bottle neck. Unload your table to a hashed file and reference that hashed file. You should see a boost in your job performance.
P.S: Job tuning, sometimes, may and will require design changes. Make that clear to your client.
by DSguru2B
Mon Jun 11, 2007 6:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: numeric value to trimed
Replies: 7
Views: 1362

Change the target metadata to Integer. That should take care of it.
by DSguru2B
Fri Jun 08, 2007 2:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle deadlock problem
Replies: 6
Views: 1209

Ask your DBA to check the trace file to get exacts on what exactly happened.
by DSguru2B
Fri Jun 08, 2007 2:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob
Replies: 18
Views: 7135

Dot, space and then dot.
by DSguru2B
Fri Jun 08, 2007 2:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reverse Pivot
Replies: 9
Views: 1686

Naa, I would go for a transformer stage, just like the way you do it in a server job.
by DSguru2B
Fri Jun 08, 2007 2:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hashed file lookup
Replies: 8
Views: 1980

Naa, It was a lucky stroke of the "Submit" key. :wink:
Welcome back. Good to see posts from you. Keep it up.
by DSguru2B
Fri Jun 08, 2007 1:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hashed file lookup
Replies: 8
Views: 1980

I beat you to it, gateleys :P
by DSguru2B
Fri Jun 08, 2007 1:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hashed file lookup
Replies: 8
Views: 1980

Load your source in a staging table and pass a sql join. That will be the most feasible.
by DSguru2B
Fri Jun 08, 2007 1:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob
Replies: 18
Views: 7135

What was the issue?