DSXchange

sangi1981

Thanks.
I will try to verify with support.
Thank you
Sandro

sangi1981

Hi,
so using Oracle Connector Stage, configured as:

auto-generated query = YES
table = table_name
Table Action = Append

is equivalent to:

Code: Select all

auto_generated query = NO
query = insert /*+append*/ into table_name ....

?

Is it right?
Thanks,
Sandro

sangi1981

Hi all,
I have a question about use of append hint from Oracle Connector.

I configured Connector with insert option and auto generated query.

Is there some properties that can be used to add /*+ append*/ hint?

Thanks for your answer.

Best regards
Sandro

sangi1981

Hello everyone, IBM support explained that the single commit is not an option of Oracle Connector in parallel version. In summary, it can happen to run a single commit but, in general, given the environmental parameters which was mentioned in some previous message and options of the stage, you can d...

sangi1981

Finally, I asked for IBM support ....
In a few days I will have a meeting with our official support.
Greetings

sangi1981

Hello, with my colleagues, we are carrying out some tests on dummy tables. We tried to send the job in error, focusing on exceptions generated by Oracle. The first test consisted of a job that writes on two Oracle tables: a connector with two input links. A link carry out row to delete on TABLE_1, t...

sangi1981

What happens if I set the two parameters

Code: Select all

$APT_ORAUPSERT_COMMIT_TIME_INTERVAL 
$APT_ORAUPSERT_COMMIT_ROW_INTERVAL

to zero?
Has zero value the same meaning of the record count in Connector?

I'm doing some tests.
As soon as completed, I tell you what conclusions are reached.

Sandro

sangi1981

Datastage is 8.7.
Oracle is 11G.
How can I ensure no intermediate commits?

Thanks

sangi1981

Hello, Thus, in order to apply a policy "ALL DELETE + ALL INSERT + SINGLE COMMIT" , in addition to the two input links to connector, must be set up something else? Some parameter to be set up? Can connector remain in parallel? PS: the two data flows (insert and delete) are produced by a ch...

sangi1981

I want all deletes to succeed and then all insert to succeed, and then commit all.
If some error occurs, i want to rollback all DML.
Thank you

sangi1981

Hello everyone, I have the need to implement a job that takes as input two datasets (one having records to be deleted, and one having records to be inserted) and make sure that the insert and delete query occur with a single transaction/unique commit. Is it possible? Can two inbound links to a conne...

sangi1981

Thanks for your answers. I completed some tests on the two alternatives, among which I should choose. The evidence is that, in my case, I get the shortest processing time using 8 connectors. I thought that push back query to DB Exadata using unique connector could improve performance, but the prior ...

sangi1981

Exadata DB Machine and AIX are on the same network.
Is there any guide line on choosing between the two way: 8 connector with 1 query per connector, vs 1 connector with 8 query in union?
Actually we use four node on aix, having ten dedicated phisical core.

Thank you

sangi1981

Exadata DB Machine and AIX are on the same network.
Is there any guide line on choosing between the two way: 8 connector with 1 query per connector, vs 1 connector with 8 query in union?
Actually we use four node on aix, having ten dedicated phisical core.

Thank you

sangi1981

Hello everyone, I am writing to ask an explanation about how to compose a job DS that retrieves data from multiple tables. My infrastructure is Exadata Machine, Datastage 8.7 on Aix server(10 cores). My case is as follow. In production environment, there is a job that reads 8 tables as input. This j...

DSXchange

Search found 99 matches

Append Hint in Oracle Insert from Datastage Connector

EXECUTE TWO DML IN ONE TRANSACTION/UNIQUE COMMIT - ORACLE

RULES TO RETRIEVE DA FROM MORE TABLES IN ONE JOB