Search found 116 matches

by nivas
Sat Jul 24, 2004 8:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting MaxValue only to a file without using Aggregator
Replies: 12
Views: 3336

Chulett

Thanks for your support and information. I donot have remote access. As you suggested I am going to develop jobs on Monday at office.

thanks
NIvas
by nivas
Fri Jul 23, 2004 9:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting MaxValue only to a file without using Aggregator
Replies: 12
Views: 3336

Hi I did not understand the link between the max value I got in the server job and the $userstatus in the next activity stage. How do I pass the max value I got in the first server job and how do I get that value in the next job through $userstatus. By the way can we find the end of processing of re...
by nivas
Fri Jul 23, 2004 8:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting MaxValue only to a file without using Aggregator
Replies: 12
Views: 3336

Hi

Is there any way by providing a constraint and send the the max value to output link, after end of reading and processing of all input records.
Please suggest.

thanks
Nivas
by nivas
Fri Jul 23, 2004 8:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting MaxValue only to a file without using Aggregator
Replies: 12
Views: 3336

Hi My idea is first get a max value in a stage variable. I would like to execute a script which runs after successiful execution of job and inserts the max value into database. I would like to define a job parameter and assign the stage variable value into Job parameter, there by I can pass the Job ...
by nivas
Fri Jul 23, 2004 6:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting MaxValue only to a file without using Aggregator
Replies: 12
Views: 3336

Hi

The source is a table. After reading all the input records and finding the max value I would like to insert into table once . I would like to avoid multiple times contacting database. Source has 16 million records . Please suggest.

thanks

Nivas
by nivas
Fri Jul 23, 2004 4:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting MaxValue only to a file without using Aggregator
Replies: 12
Views: 3336

Inserting MaxValue only to a file without using Aggregator

Hi

I am getting a sequece of values From one input column. After completion of job I would like to insert only the max of input column value into a seq file or a table without using aggregator. Could any body please give me suggestion.

thanks
NIvas
by nivas
Mon Jul 19, 2004 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference between File Set and Data Set
Replies: 6
Views: 5458

mandyli wrote:Based on volume of data you can choose file or data set.
My assumption is For High volume we should go FileSet and the DataSet for the latter. Am I correct?
by nivas
Mon Jul 19, 2004 11:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Keys Options
Replies: 5
Views: 3639

Re: Surrogate Keys Options

nivas wrote:I think instead of using seq file using Hash file is better.

thanks
Nivas
Hi

I am sorry. I am wrong. Please check the forum question and ans which was posted on June 22nd. Priviously I got the ans.

thanks
Nivas
by nivas
Mon Jul 19, 2004 11:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Keys Options
Replies: 5
Views: 3639

Re: Surrogate Keys Options

I think instead of using seq file using Hash file is better.

thanks
Nivas
by nivas
Thu Jun 10, 2004 4:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generation Of Surrogate Keys
Replies: 3
Views: 2512

Generation Of Surrogate Keys

We are about to start development in Parallel Jobs. I am putting this question in curiosity.How do we Generate Surrogate Keys in Parallel Jobs? Is there any difference from the same in Server jobs.
Any suggestions are appreciated.

thanks

Nivas