Search found 8 matches

by ameet.penkar
Mon May 15, 2006 11:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transaction Control between normal and aggregated data
Replies: 3
Views: 1382

Re: Transaction Control between normal and aggregated data

Hi The failure of both detailed as well as summarised data is the failure of upsert on the target tables. Will transaction control be of help in this scenario? Hi Is there any additional constraint for the failure of summarized data or is it the same as molecular data? If it's the same then you can ...
by ameet.penkar
Mon May 15, 2006 9:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transaction Control between normal and aggregated data
Replies: 3
Views: 1382

Transaction Control between normal and aggregated data

Hi My requirement is quite unique. There is a normal table and a aggregated table. The data for both the tables comes from the same transformer,but before putting the data in the aggregated table,it needs to be aggregated. Hence the transaction control desired is somnething like this. 1)If any of th...
by ameet.penkar
Tue Jan 24, 2006 12:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Oracle stage(OraOCI9)
Replies: 12
Views: 5354

I applied the patch.However,It did not make any difference. That would make sense as the patch is not meant for that particular problem at all. I'd suggest you uninstall and reinstall the client once more. Double-check in between that everything is actually being removed. Rebooting after the uninst...
by ameet.penkar
Mon Jan 23, 2006 8:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Oracle stage(OraOCI9)
Replies: 12
Views: 5354

MaheshKumar Sugunaraj wrote:Hi Ameet,

I have mailed the Patch, Hope its solved your issue.

WIth Regards
M
Hi Mahesh

I applied the patch.However,It did not make any difference.

Regs
Ameet
by ameet.penkar
Mon Jan 23, 2006 3:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Oracle stage(OraOCI9)
Replies: 12
Views: 5354

Hi Ameet, Please check if your OS is Windows XP, if Yes then u need to install a Patch and if No, then you need to check with the Support Team. With Regards M Mahesh,my workstation OS is XP.can you please let me know which Patch are you referring to?(the name of the patch).This will be of great hel...
by ameet.penkar
Mon Jan 23, 2006 3:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Oracle stage(OraOCI9)
Replies: 12
Views: 5354

Re: Problem with Oracle stage(OraOCI9)

nishant_prakash wrote:hi, did u check your user priviliges in administrator???It could be that you have insufficient priviliges to see the properties...

Regds,
Nick

There are no problems when i use the same user from any other machine.
THis problem has started surfacing only recently.
by ameet.penkar
Mon Jan 23, 2006 1:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with Oracle stage(OraOCI9)
Replies: 12
Views: 5354

Problem with Oracle stage(OraOCI9)

I am not able to see the properties of the Oracle stage(OraOCI9) in my jobs.The job hangs on attempting to do so. However,I am able to do a view data on the link which is connected to the same Oracle stage. Other team members using the same project with the same user do not face this problem. I have...
by ameet.penkar
Fri Sep 17, 2004 1:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to import/manually code Number datatype(Oracle) into DS
Replies: 2
Views: 1222

how to import/manually code Number datatype(Oracle) into DS

Hi

In our back end, one of the columns is defined as Number(NO Precision and NO scale given).When metadata is imported, DS takes it as Decimal(38,0).
In practice, we require the Scale very much, and the job gives warnings

Any suggestions on how to tckle this?

Ameet