Search found 53125 matches

by ray.wurlod
Tue Jan 10, 2012 3:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Get rows based on a condition
Replies: 13
Views: 4656

Trivium for today: RUMPELSTILTSKIN fits diagonally (if not legally) on a Scrabble board.

Question: if it were legal, what would it score?
by ray.wurlod
Tue Jan 10, 2012 3:12 pm
Forum: General
Topic: SQL Server ODBC issue
Replies: 4
Views: 1572

Can you import a table definition from that source?
by ray.wurlod
Tue Jan 10, 2012 3:10 pm
Forum:
Topic: Need help in using metadata workbench
Replies: 39
Views: 14459

If you're running version 8.7, you don't delete directly if workflow is enabled. Rather you "mark for deletion" in the Development Glossary then go through correct governance (submit for approval, approval) before publishing into the Published Glossary.
by ray.wurlod
Tue Jan 10, 2012 1:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compilation error on transformer stage
Replies: 8
Views: 4763

Have you set the environment variables PATH, LIB, LIBPATH, APT_COMPILER, APT_COMPILE_OPTIONS, APT_LINKER and APT_LINKER_OPTIONS correctly? Have you installed the Platform SDK?
by ray.wurlod
Tue Jan 10, 2012 1:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Adding table partition from DS server job
Replies: 4
Views: 1817

Surely the table only needs to be partitioned once. As you send a stream of data to the table, Oracle will worry about which partition to load each record into.
by ray.wurlod
Tue Jan 10, 2012 1:19 am
Forum: General
Topic: Need a small help... please comment why job always crashes
Replies: 12
Views: 2225

On the client. Change them with any image editor that handles bitmaps, even MS Paint (I think). On your own head be it!
by ray.wurlod
Tue Jan 10, 2012 1:18 am
Forum: General
Topic: istool syntax
Replies: 30
Views: 52296

Re: Encrypt password

thank you for the details on the utility "istool". Is it possible to encrypt password ? This is possible in version 8.7. You can also (in 8.7) use an -authfile option to specify a file containing authentication information - the password can be encrypted there also. IBM provides encrypt.b...
by ray.wurlod
Tue Jan 10, 2012 1:15 am
Forum: General
Topic: List Users by Project
Replies: 7
Views: 5012

You can list users with DirectoryAdmin, but not per-project as far as I can tell. For example:

Code: Select all

DirectoryAdmin.sh -user -search -idp a* -max_count 100
This returns at most 100 user IDs which begin with "a".
by ray.wurlod
Tue Jan 10, 2012 1:10 am
Forum:
Topic: Need help in using metadata workbench
Replies: 39
Views: 14459

I've just installed Business Glossary and there were no categories in it. I suspect one of your colleagues created ABC.
by ray.wurlod
Mon Jan 09, 2012 3:36 pm
Forum: General
Topic: DS job load validation
Replies: 7
Views: 2019

Download ETLstats from Kim Duke's website and adapt it to your specific needs. Indeed, ETLstats may suit your needs "out of the box".
by ray.wurlod
Mon Jan 09, 2012 3:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: StringToDate unusual scenario
Replies: 7
Views: 1765

How do you know that you're receiving previous century's data? Leverage that knowledge to process your dates correctly.
by ray.wurlod
Mon Jan 09, 2012 3:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Assigning RAM disk to scratchdisk resource on AIX 5.3
Replies: 1
Views: 884

Welcome aboard.

The answer is "probably" only because RAM disk access time is so much faster than spinning disk access time, particularly for random access where the spinning disk heads have to move frequently.
by ray.wurlod
Mon Jan 09, 2012 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal Rounding based on Parameter
Replies: 3
Views: 1362

I suspect this is not possible. What have you tried, and with what result?

Have you considered a Modify stage? Pretty much everything in a Modify stage can be parameterized.
by ray.wurlod
Mon Jan 09, 2012 3:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Increment Values based on two columns (Looping)
Replies: 3
Views: 1049

You probably should check that Arg2 > Arg1 at the beginning so that you don't generate an infinite loop.
by ray.wurlod
Mon Jan 09, 2012 3:21 pm
Forum: General
Topic: DS jobs and its logs physical storage
Replies: 9
Views: 1968

priyadarshikunal wrote:ORLogging is the correct term to be searched for. It is a enviroment variable.
RTLogging and ORLogging are not environment variables. They are entries in the DSParams file for a project that control where logging is performed.