DSXchange

Hi,

I do not have the pdf with me nor do I ahve the DSEE 7.5. Can you please send the document to mohan.suswaram@wipro.com?

Cheers,
Mohan

Hello,

I haven't worked on DataStage 7.5.But I heard that in DS 7.5 Oracle Stored Procedures can be used using a OCI stage.

May I know how it works?

Cheers,
Mohan

Hi, I have a wierd scenario here. My parallel jobs are failing in one project and the same are succeeding in the other. I have a parallel job which loads first into a Dataset and then another job loads the table reading from the Dataset. The data is being written into the Dataset without any issues....

Thanks kduke and Ray..

Cheers,
Mohan

Hi, I was running dataset to Oracle load jobs...I encountered the following errors: Stg_AdcCustomerNodeHistory_Load: query 'select count(*) from ALL_PART_INDEXES where TABLE_NAME = upper('STG_ADC_CUSTOMER_NODE_HISTORY') and OWNER = upper('HUBPRODSTG') ' returned 0 Stg_AdcCustomerNodeHistory_Load: In...

Hi, When I run my data load jobs, what I see on the canvas is the number of rows loaded and the no. of rows loaded per sec (load rate). But I'm more concerned with the data load in terms of MBs or GBs because what I load is huge tables. So, more than the number of rows, I would be more interested in...

Hi..

Thanks for the responses.

I was able to download MS JVM and was able to run MetaStage explorer.

Thanks again..

Cheers,
Mohan

Thaks a lot for the information.

Cheers,
Mohan

Hi, There's a job with some BASIC coding in it. I tcontains ODBC.H. When it was run some 2-3 weeks ago, it ran fine. When it was run today, I received the following error: "ServerAlertCode..JobControl (): Call to SQLExecDirect failed. sqlstate=HY000, dbms.code=6091 [DataStage][SQL Client][ODBC]...

Thanks a lot for your responses..

Cheers,
Mohan

Ha ha ha....

I thought so Ray..just wanted to make sure...

Thanks Ray...

Cheers,
Mohan

Hi,

I need to load data from 20 huge tables. If I use DS Enterprise Edition, I can do it in some time. But if I were able to copy the tablespaces, it happens in almost no time.

Does DS provide any functionality whereby I can copy tablespaces?

Cheers,
Mohan

Nopes....it didn't....

It didn't write even a record..

Cheers,
Mohan

Well...that's a gud question. We are lagging at space but we have enough space to accomodate data. What's the point that you are trying to make?

Cheers,
Mohan

Hi,

I'm not doing any aggregation. It's a plain one-to-one job (matching columns).

Cheers,
Mohan