Search found 53125 matches

by ray.wurlod
Wed Jan 04, 2012 7:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copy stage active or passive?
Replies: 21
Views: 5971

Not columns. A Copy stage (passive) can quite happily drop (not transfer) some columns. This does not represent a change to the data.
by ray.wurlod
Wed Jan 04, 2012 7:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset update policy
Replies: 6
Views: 2675

What do YOU think the difference between the two scenarios is? In particular, under what circumstances might the second be appropriate?
by ray.wurlod
Wed Jan 04, 2012 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Convert the Timestamp value to BigInt
Replies: 13
Views: 7990

Is the Scale value in the metadata set to 6?
by ray.wurlod
Wed Jan 04, 2012 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORACLE performance
Replies: 7
Views: 4428

Are these, or some of them, materialized views?

How complex are the constraints in the query? How complex are the join criteria?
by ray.wurlod
Wed Jan 04, 2012 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copy stage active or passive?
Replies: 21
Views: 5971

You can put it in any folder you like. The repository is entirely customisable. The location of a stage type does not affect its other properties.
by ray.wurlod
Wed Jan 04, 2012 2:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COnfiguration file
Replies: 8
Views: 1866

If you didn't understand that, then your best course it to take the IBM class "DataStage Essentials" or some equivalent. This is so fundamental a concept to running parallel jobs.
by ray.wurlod
Wed Jan 04, 2012 2:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage configuration file
Replies: 5
Views: 3394

chandra.shekhar@tcs.com wrote:
arvind_ds wrote:You can start with below.

No of nodes = Half the number of cores.
Means that I can use following combination.

10 cpu =20 Nodes and 9 cpu =18 nodes.
No it doesn't. It means
10 cpu = 5 nodes and 9 cpu = 5 nodes.
by ray.wurlod
Wed Jan 04, 2012 2:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Changing the colour of the link in server job
Replies: 11
Views: 3314

This is singularly useful when the developer is red-green colour blind. I had such a client once, and changed the good/bad colours to yellow and purple, which he could see and differentiate.
by ray.wurlod
Wed Jan 04, 2012 2:49 pm
Forum: General
Topic: What is the purpose of the HA_STATUS DS project subdirectory
Replies: 5
Views: 3045

Curious. Looks like DS is checking the HA status for some reason. Can you review your installation log to make sure that no HA piece was enabled? Contact support to find out how to disable it, and do let us know.
by ray.wurlod
Wed Jan 04, 2012 2:47 pm
Forum: General
Topic: Retrieving the InfoSphere domain user who executed a job
Replies: 3
Views: 1097

Not unless the job design reports it.
by ray.wurlod
Wed Jan 04, 2012 2:46 pm
Forum: General
Topic: Latest logdetails using RT_LOG file
Replies: 4
Views: 2025

There is no flag. You could, of course, determine the most recent "job started" event by constraining on max of TIMESTAMP and event type.
by ray.wurlod
Wed Jan 04, 2012 2:44 pm
Forum: General
Topic: parameterizing the transformation functions
Replies: 16
Views: 4575

Data Rule Definitions can be created in either DataStage or Information Analyzer. They are compatible - rule definitions published into the common metadata repository by one tool can be used by the other.
by ray.wurlod
Wed Jan 04, 2012 2:42 pm
Forum: General
Topic: Importing FastTrack Mapping Specifications from CSV
Replies: 4
Views: 1378

Thanks, Eric. Alas my client seeks to have a fully automated process.
by ray.wurlod
Tue Jan 03, 2012 10:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Special characters Issue loading in DB
Replies: 16
Views: 3558

Show us what your data look like in vi or cat -vt or similar.
by ray.wurlod
Tue Jan 03, 2012 10:02 pm
Forum: General
Topic: Importing FastTrack Mapping Specifications from CSV
Replies: 4
Views: 1378

Note that istool import ... -fasttrack '<options>' only imports from an assets archive (a ".isx" file), it does not appear to support CSV format.