Search found 53125 matches

by ray.wurlod
Wed Jun 11, 2014 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to convert columns into Rows with metadata?
Replies: 13
Views: 3788

pkll wrote:If I will create 50 Dummy columns performance will decrease
Prove it.
by ray.wurlod
Wed Jun 11, 2014 5:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Merge stage clarification
Replies: 5
Views: 1644

Clarification 1 - it's obvious that there is no row from the Update link in this case.

Clarification 2 - you can choose not to add reject links at all to the Merge stage.
by ray.wurlod
Wed Jun 11, 2014 4:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What are dmp files in DS Client path for?
Replies: 4
Views: 2996

bmarko22 wrote:How do we turn these off?
You create jobs that don't fail.
by ray.wurlod
Wed Jun 11, 2014 4:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00060: deadlock detected while waiting for resource
Replies: 12
Views: 8931

Might any other applications be touching (locking) the IOA_SOURCE_MOLI table?
by ray.wurlod
Wed Jun 11, 2014 4:53 pm
Forum: General
Topic: sequence log clarifacation
Replies: 5
Views: 873

Re: sequence log clarifacation

vamsi.4a6 wrote:I need to capture the log for all 10 jobs+sequence from unix in a text file whenever i run the sequence.
Why?

The logs are right there to be viewed in Director.
by ray.wurlod
Wed Jun 11, 2014 4:52 pm
Forum: General
Topic: Metadatawork bench clarification
Replies: 3
Views: 894

(1) Yes.
(2) Depends what you mean by difficult. Basically no. It's a browser connection to a set of services. Admin for DataStage already administers IIS.
(3) Basically no. It's a browser connection to a set of services.
by ray.wurlod
Wed Jun 11, 2014 4:48 pm
Forum: General
Topic: Quick Find doesn't find stage names
Replies: 2
Views: 1240

Neither stages nor links are independent repository objects, which is why you can't select them and why you can't search for them.

As noted, Metadata Workbench is the preferred tool for searching for named components.
by ray.wurlod
Wed Jun 11, 2014 4:45 pm
Forum: General
Topic: Adding a Datastage Engine to an existing Infosphere Service
Replies: 6
Views: 3548

No matter what you do, if you increase the number of processors (CPU cores) you will be up for increased licensing cost. Licensing is based on "processor value units" which also take into account processor type and speed. Job designs should not need to be changed, or even re-compiled. What...
by ray.wurlod
Wed Jun 11, 2014 4:43 pm
Forum: General
Topic: Datastage QualityStage License
Replies: 4
Views: 1674

Hint: You need to research further which products are included in IBM Information Server for Data Quality.
by ray.wurlod
Wed Jun 11, 2014 4:40 pm
Forum: General
Topic: Pass multiple lines or rows as parameter
Replies: 5
Views: 1513

You can, but only up to a limit of about 64KiB, as you have discovered. There is no environment variable for changing this limit, at least not one of which I'm aware. You might find one from your official support provider. You may need to contemplate a different approach - perhaps an External Source...
by ray.wurlod
Wed Jun 11, 2014 4:35 pm
Forum: General
Topic: DataStage Installation
Replies: 4
Views: 538

Might this be permissions issues on the client machine? In particular look in and below "C:\IBM\InformationServer\Clients\Classic".
by ray.wurlod
Wed Jun 11, 2014 12:53 am
Forum: IBM QualityStage
Topic: TransGender
Replies: 6
Views: 4490

TransGender

I've just spent a little while teaching QualityStage to recognise that LADY QUENTIN BRYCE (Australia's recently-ex Governor General) needs GenderCode F.

Can anyone work out how to convince QualityStage that DAME EDNA EVERAGE is a bloke?

:lol:
by ray.wurlod
Wed Jun 11, 2014 12:45 am
Forum: General
Topic: Pass multiple lines or rows as parameter
Replies: 5
Views: 1513

Any form of delimited string.

If you think about it, that's all a file is, with line terminator as the delimiter.

Of course, the Before/After subroutine will need to unpack the delimited string. Even if you persevere with using line terminator as the delimiter.
by ray.wurlod
Wed Jun 11, 2014 12:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Timestamp Format Changes In Hash File
Replies: 2
Views: 1904

The hashed file does not have any timestamp (or any other) data type. Can you perhaps make the field a little wider, to see whether there's an AM/PM designator terminating it?

You might also try setting the column definition in the Hashed File stage to have a Data Element of Timestamp.