Search found 5168 matches

by kumar_s
Thu Apr 20, 2006 12:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need project or jobs created on datasatge for practice quest
Replies: 2
Views: 999

Welcome Aboard :D

First go through the given documentation. Search the forum. Join the training offered.
by kumar_s
Thu Apr 20, 2006 12:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with Universe Stage
Replies: 28
Views: 5687

ArndW wrote:Kumar - GRANT is a DataStage command. The error seems to revolve around those quirky Windows domain ids and I'm not at such a system right now so can't help - the command should have worked.

Thanks for correcting me Arnd :D
by kumar_s
Thu Apr 20, 2006 12:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RenameAllJobs - Easy ?
Replies: 22
Views: 5265

NO.....
NAME in DS_JOBOBJECS does not gets automatically updated. Need to do manually.
Updating dsx would update the both.
by kumar_s
Thu Apr 20, 2006 12:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Reset and Log Reset
Replies: 6
Views: 1610

Re: Job Reset

Resetting a job from either finihed state or from aborted state brings back the job in a stage to be able to recompile the job. Hence by resetting the job, we are able to bring back the job in a runnable state. thanks, Tom Compilation does not require the job to be in runnable state. Unless the job...
by kumar_s
Wed Apr 19, 2006 8:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with Universe Stage
Replies: 28
Views: 5687

GRANT DBA TO velag001 is not UV command, its a DB command.
Grand previlage to the userid from OS level.
by kumar_s
Wed Apr 19, 2006 8:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with Universe Stage
Replies: 28
Views: 5687

Arnd - Isnt it giving prompt while tyring update to UV_USERS.
velagapudi - BTW what if you query >SELECT DBAUTH FROM UV_USERS WHERE NAME='velag001'; now.
by kumar_s
Wed Apr 19, 2006 8:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with Universe Stage
Replies: 28
Views: 5687

But what is the id you use to login?
Try using dsadm.
by kumar_s
Wed Apr 19, 2006 8:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file creation in Project dir
Replies: 4
Views: 879

Migration may be easy but Maintanance become tough :wink:
by kumar_s
Wed Apr 19, 2006 8:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating Header/Detail/Summary records in one output file
Replies: 12
Views: 4466

You can select your desired delimiter in the Start loop activity.
by kumar_s
Wed Apr 19, 2006 8:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Triggers in Sequencer
Replies: 3
Views: 892

Also check the link name in the trigger condition.
by kumar_s
Wed Apr 19, 2006 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strategy for Null handling for sequential file processing
Replies: 3
Views: 1362

For the not null input field in aggregator output doesnt require null handling. But most likely to have a data type conversion. :wink:
by kumar_s
Wed Apr 19, 2006 7:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: surrogate key generation in server jobs
Replies: 13
Views: 5268

But for many case surrogate key would be requred even before the target for change detection. If source is not from database, it would be required to generate a unique key for identification.
by kumar_s
Wed Apr 19, 2006 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Space Constraint
Replies: 7
Views: 1654

IPC and buffer setting shouldnt leave out a persistent file.
by kumar_s
Wed Apr 19, 2006 7:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Where is the job located
Replies: 3
Views: 1100

You can find many files under project directory with RT_* which holds these informations.