Search found 14 matches

by madhava1238
Wed Jun 11, 2008 2:49 am
Forum: General
Topic: job locks release
Replies: 3
Views: 2506

job locks release

Hi
all,

how to release locked jobs?and wher?

and i have run a job on unix Operating system in which path the job is running

Regards,
Madhava.
by madhava1238
Thu Jun 05, 2008 4:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Colletor Working
Replies: 10
Views: 3734

no need of SMP systems

it's working in single processor system also no need of SMP

Regards,
Madhava.
by madhava1238
Tue Jun 03, 2008 4:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple rows to single row
Replies: 3
Views: 2819

Hi

by using row merge stage and implement CRC logic and adding a key column then only u can get answer.

OR

take an aggregator stage in output columns put each and every column is max(column name) then u can get the answer
by madhava1238
Tue Jun 03, 2008 4:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: performancce tunning
Replies: 3
Views: 3082

Hi

by using row merge and row split stages and interprocess stage we can improve the job performance
by madhava1238
Tue Jun 03, 2008 3:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: i want duplicate rows also
Replies: 1
Views: 1257

i want duplicate rows also

Hi all, i have a small scenario seq>>>lookup hash file....>.>target file in hash file i have same customer name(ex a) with different salaries seq file i have only one record and customer name is(ex a) by comparing i want same customer name with different salaries.. is it possible or not Thanks &...
by madhava1238
Tue May 27, 2008 6:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: need last 5 transactions
Replies: 2
Views: 1833

need last 5 transactions

Hi All, i have a small scenario, can u pls send answer any one... a customer having fields date,Narration,Ref/cheq.no,value date,withdraw amount,deposit amount,closing balance(this one is sopurce data) i want last 5 transactions in target date seq..file....> tranformer.......>seq ..file format Thank...
by madhava1238
Wed May 21, 2008 6:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: solution
Replies: 4
Views: 2051

getting solution

Hi
iwas getting answer,

seq.....> aggregator....... .>transfor........>seqfile

in Aggregator we r grouping max(col name) to all then we will get the required format


Regards,
Madhava.
by madhava1238
Wed May 21, 2008 5:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: solution
Replies: 4
Views: 2051

solution

Hi
All,

i have a file like this(data is like this)

a - -
- b -
- - c

and i want result is:
a b c


Thanks & Regards,
Madhava
by madhava1238
Fri May 16, 2008 5:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: counts
Replies: 5
Views: 2830

Thanks ram

completed successfully
by madhava1238
Fri May 16, 2008 4:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: counts
Replies: 5
Views: 2830

counts

here ihave 3 departments in source table

and iwant individual counts of the departments as target table.



Thanks & Regards,
Madhava
by madhava1238
Fri May 16, 2008 4:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hi
Replies: 4
Views: 2295

sequential file asa input and transformer and then target also sequencial file
by madhava1238
Fri May 16, 2008 4:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: use of row merge stage
Replies: 2
Views: 2703

use of row merge stage

Hi
All

what is the use of row merge stage?

can u pls tell me crc32 routine uses?


thanks & Regards,
Madhava
Virtusa(india)Pvt Ltd
chennai
by madhava1238
Fri May 16, 2008 3:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hi
Replies: 4
Views: 2295

Hi

Hi All ihave a file like this company id,price,product, startdate,enddate 1 , 10 ,a ,1/1/07 ,6/1/07 1 , 20 ,a ,4/1/07 ,6/1/07 ... .... here all products end date 6/1/07 but iwant product a enddate(3/1/07) at price rate is 10.. result: company id,price,product, startdate,enddate 1 , 10 ,a ,1/1/07 ,3/...
by madhava1238
Fri May 16, 2008 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: counts
Replies: 5
Views: 2830

counts

how to take individual counts of a particular table