Search found 5168 matches

by kumar_s
Mon Mar 05, 2007 4:24 am
Forum:
Topic: Metastage scalability
Replies: 8
Views: 3421

Welcome to DSXchange :D !!!

Metastage in version 8 of Datastage is clubbed in to single pack. Datastage itself will have single point of common repository.
by kumar_s
Mon Mar 05, 2007 4:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to assign sequence numbers to sorted data ?
Replies: 7
Views: 1573

Use stage variable in Transformer,

Code: Select all

Intial Assignment  vPreKey = 1

Counter => If Input.ChangeKeyColumn = 0 Then PreKey + 1 Else 0
vPreKey = Counter


Assing Counter to a Field.

Oh sorry, just now I notices that the post has been repeated.
by kumar_s
Mon Mar 05, 2007 4:13 am
Forum: General
Topic: Parallel installs of DS 7.1 and 7.5.1
Replies: 9
Views: 4902

Do you mean scripts involving Port No :shock: .
If you are referring to command line executables, it will refer to the user id to which the corresponding dsenv is configured.
by kumar_s
Mon Mar 05, 2007 4:11 am
Forum: General
Topic: Live Data Feed capturing through DS
Replies: 10
Views: 3880

RTI stage plugin is available. Or MQ.
Can you explain bit more on your requirement.
by kumar_s
Mon Mar 05, 2007 4:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_BadAlloc: error while processing data in an aggregator
Replies: 7
Views: 3091

Hi and Welcome to Dsxchange :D !!!! This has been discussed already. If make a search on this site, you can find lot of post. If your "Method = Hash" Change it to Sort. Check if the temp / Scratch disk is getting full when you run the job which has Aggregator stage. It may also be due to 2GB limit o...
by kumar_s
Mon Mar 05, 2007 4:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to assign sequence numbers to sorted data ?
Replies: 7
Views: 1573

Hope you are using Sort stage for sorting the data in the order. User "Create Key Change column" option in the Sort stage which will enable you additional field. This will assign 1 to each new group. User Transformer stage to store the previous record in a stage variable and add 1 till you find the ...
by kumar_s
Mon Mar 05, 2007 4:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to assign sequence numbers to sorted data ?
Replies: 7
Views: 1573

Hope you are using Sort stage for sorting the data in the order. User "Create Key Change column" option in the Sort stage which will enable you additional field. This will assign 1 to each new group. User Transformer stage to store the previous record in a stage variable and add 1 till you find the ...
by kumar_s
Mon Mar 05, 2007 4:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to assign sequence numbers to sorted data ?
Replies: 7
Views: 1573

Hope you are using Sort stage for sorting the data in the order. User "Create Key Change column" option in the Sort stage which will enable you additional field. This will assign 1 to each new group. User Transformer stage to store the previous record in a stage variable and add 1 till you find the ...
by kumar_s
Mon Mar 05, 2007 1:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dsx Change
Replies: 4
Views: 1065

Yes, search for "JobVersion" and change it.
by kumar_s
Mon Mar 05, 2007 12:12 am
Forum: General
Topic: DCS-Strategies 10 years of thanks
Replies: 8
Views: 2628

Logo gonna be changed again :!: :shock:
by kumar_s
Mon Mar 05, 2007 12:08 am
Forum: General
Topic: DsEngine Function
Replies: 3
Views: 1319

When you execute a job from a client application, you are executing the job Executable available in Sever, and hence executed in server by DSEngine.
by kumar_s
Mon Mar 05, 2007 12:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to delete the indexes of a table using routine
Replies: 8
Views: 1947

What is the stage you are using to load the data.
Oracle Enterprise stage has "Index mode" as a option, where you can select "Rebuild". Where these drop and recreate will be taken care by Datastage.
by kumar_s
Mon Mar 05, 2007 12:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help on dsexport
Replies: 40
Views: 15946

Kim, I wasn't there when you changed the color, can to start again from first.
by kumar_s
Sun Mar 04, 2007 11:58 pm
Forum: General
Topic: Problem logging into a DS project
Replies: 10
Views: 2760

Its time for you to mark the thread as "Resolved". :)
by kumar_s
Sun Mar 04, 2007 11:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: writing Null field on a fixed width sequential file
Replies: 21
Views: 4869

A Recent note by Ray states that, IBM has announced Transformer is much faster than Filter stages. And afterall the Transformer stage plays a very vital role in the 'T' in ETL and the next should be Modify in PX.
Pls explain the full job design, lets see if its possible without the stages.