Search found 53125 matches

by ray.wurlod
Thu Apr 09, 2015 4:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Stage CSV column seperation to Multiple rows
Replies: 4
Views: 1445

I would have thought that the Column Import stage could have been involved here, prior to Pivot.
by ray.wurlod
Thu Apr 09, 2015 4:09 pm
Forum: General
Topic: Run script using multi instance job
Replies: 3
Views: 860

The instances run in separate processes. Each process can run the script, assuming that there's nothing in the script (such as writing to a specifically-named file) that would prevent simultaneous execution.
by ray.wurlod
Wed Apr 08, 2015 4:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Condition
Replies: 5
Views: 3052

Consider the behaviour of the Lookup stage when the Lookup Failed rule is Continue. With Lookup Failed set to Drop and Condition Not Met set to Continue, the same behaviour will obtain for records in which the condition is not met. However, the condition can not use data from the reference input lin...
by ray.wurlod
Wed Apr 08, 2015 4:54 pm
Forum: General
Topic: Run jobs by calling value file automatically
Replies: 1
Views: 720

You could use a StartLoop activity processing a delimited list of values file names.
by ray.wurlod
Tue Apr 07, 2015 4:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Incorrect delete record count in job log
Replies: 12
Views: 3797

The language of the report could be improved. It is advising that one row was sent to the database server, and that the operation to be performed was DELETE. (The assumption is that the Key here is a unique primary key which, in your case, it is not.)
by ray.wurlod
Tue Apr 07, 2015 3:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NZ sql script calling
Replies: 6
Views: 2876

Better idea. Why don't you press the Help button when these properties are selected, learn what the possible values are and the effects of each, and report back with your findings?
by ray.wurlod
Thu Apr 02, 2015 5:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: InfoSphere CDC: Update metadata definition of source table
Replies: 0
Views: 1359

You probably do need to unsubscribe to effect such a change.
by ray.wurlod
Thu Apr 02, 2015 5:08 pm
Forum: General
Topic: Not able to view jobs in datastage 8.7 Director
Replies: 6
Views: 1489

Not a good solution. You should, rather, clear the status file using Director client, or a CLEAR.FILE command in dssh (perhaps from Administrator client).
by ray.wurlod
Wed Apr 01, 2015 2:57 pm
Forum: General
Topic: Derive the host name and project name dynamically
Replies: 6
Views: 1683

There's no such thing as a Sequencer job. It's a Sequence job. A Sequencer is a component that can be used in a Sequence job.
by ray.wurlod
Wed Apr 01, 2015 2:54 pm
Forum:
Topic: Will Metadata workbench show Transformation rule (DS 9.1)
Replies: 4
Views: 4653

Yes, except that Metadata Workbench has been subsumed into Information Governance Catalog (along with Business Glossary), it still works basically the same way.
by ray.wurlod
Wed Apr 01, 2015 2:53 pm
Forum: Enhancement Wish List
Topic: Glossary "Submit for Approval"
Replies: 2
Views: 6773

It's true that they don't have to be submitted individually from the Drafts, Awaiting Approval or Approved pages, but it is true that they have to be submitted individually from the Browse Terms or Browse Categories pages. I used the same strategy mentioned by qt_ky, but working backwards from highe...
by ray.wurlod
Tue Mar 31, 2015 9:41 pm
Forum: Enhancement Wish List
Topic: Glossary "Submit for Approval"
Replies: 2
Views: 6773

Glossary "Submit for Approval"

Found in version 11.3.1, possibly exists in earlier versions... When one has a long list of Terms (let's say 250 or so terms, displayed 50 per page) and wants to submit some from page 5 for approval, they have to be submitted individually and, after each has been submitted, one is returned to the be...
by ray.wurlod
Tue Mar 31, 2015 6:38 pm
Forum: General
Topic: Internet of Things
Replies: 0
Views: 921

Internet of Things

IBM's worldwide head of marketing for the InfoSphere brand, Mr Asif Ittiso, today announced a number of new initiatives for the InfoSphere products, in particular the Information Server, Guardium and Optim suites of products, in relation to the "Internet of Things" (IoT), by which is meant...
by ray.wurlod
Tue Mar 31, 2015 6:30 pm
Forum: General
Topic: IBM Champion (Information Management) Nominations Now Open
Replies: 5
Views: 3270

Guess it doesn't need to be sticky any more...
by ray.wurlod
Tue Mar 31, 2015 3:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Varchar (SQL Server) to Decimal (Oracle) conversion
Replies: 3
Views: 1806

Did you include a value of 2 for Scale in the metadata? Have you specified a format string in your StringToDecimal() function call?