Current Position:Home > How to UPDATE a big table in Oracle via Bulk Load

How to UPDATE a big table in Oracle via Bulk Load

Update:10-11Source: network consolidation
Advertisement
Hi all,
in a datastore target as Oracle 11g, I have a big table having 300milions of record; the structure is One integer key + 10 columns attributes .
In IQ Source i have the same table with the same size ; the structure is One integer key + 1 column attributes .
What i need to do is to UPDATE that single field in Oracle from the values stored in IQ .
Any idea on how to organize efficiently the dataflow and the target writing mode ? bulk load ? api ?
thank you
Maurizio

The Best Answer

Advertisement
Hi,
You cannot do bulk load when you need to UPDATE a field. Because all a bulk load does is add records to your table.
Since you have to UPDATE a field, i would suggest to go for SCD with
source > TC > MO > KG >target
Arun
  • How to UPDATE a big table in Oracle via Bulk Load Update:10-11

    Hi all, in a datastore target as Oracle 11g, I have a big table having 300milions of record; the structure is One integer key + 10 columns attributes . In IQ Source i have the same table with the same size ; the structure is One integer key + 1 colum

  • Update Global Temp Table in Oracle 11g Update:11-30

    Hi Experts, Scenario: I have stored  procedure A which calls procedure B. Procedure B uses Global temp Tables(With On Commit Preserve Rows)  to work with the data. I am trying to update one of the GTT in Proc B but unable to do it .. via SQL or via P

  • How to load empty column from flatfiles to tables in oracle using aql*loade Update:11-30

    HI,, i am trying to load data from flat files to oracle tables using sql*loader. i got empty column to load. while i am trying it is throwing an error as null colums canot load... plz help me with this... Thanks in adavnce..I believe you need to use

  • API to update oracle base table in oracle apps Update:11-30

    Hi, What is the API used to update a base table in oracle contracts? Please suggest.If you are on 11i, please check irep.oracle.com It lists all APIs available. IREP - Oracle Integration Repository: The Tool To Find Which API Is Supported and How To

  • HOW TO APPEND TABLE ON ORACLE DATABASE? Update:11-30

    DEAR ALL, CAN ANY ONE SUGGEST ME WITH SOME SAMPLE CODE AS TO HOW TO UPDATE AND APPEND TABLE ON ORACLE DATABASE USING SQL. EXEC SQL. APPEND TABLE FROM INT-TABLE. END EXEC. WILL THIS WORK.Check the sample code: DATA Y TYPE I VALUE 300. DATA Z TYPE I. E

  • What locks are required on a table when Oracle is processing an UPDATE Update:11-30

    What locks are required on a table when Oracle is processing an UPDATE statement?Welcome to the forum! Whenever you post provide your 4 digit Oracle version. > What locks are required on a table when Oracle is processing an UPDATE statement? > Here

  • Update Yes/No field in access table through oracle procedure Update:11-30

    Hi, How to update Yes/No field in access table through oracle procedure. all other fields like AutoNumber, Text I can update it. Yes/No field how to update? Please, any one can help me? Thanks and Regards, Sudha.Sudha Teki wrote: select "fldPost"

  • How to update/query informix table for every update/query on Oracle table Update:11-30

    We have a system that can talk to only Oracle. Here, we have a certain program that updates an Oracle table thru a View of the Table. For every database operation on Oracle table View, we want to update a corresponding table in Informix database. Sim

  • Can't update a sql-table with a space Update:10-11

    Hello, In a transaktion I'm getting some Values from a SAP-ERP System via JCO. I update a sql-table with this values with a sql-query command. But sometimes the values I get from SAP-ERP are empty (space) and I'm not able to update the sql-table beca

  • How to tune a table in oracle Update:10-11

    hi can anyone please help me in tunning a particular table in oracle which has millions of Record kindly help me for the procedure to tune the table... thanks Regards MisinWhat's the Oracle version? Does this table have LOB column ? Make sure it's on