HomeForum
Welcome, Guest

Updating Oracle table
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Updating Oracle table

Updating Oracle table 10 months ago #3290

  • Victor
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Hi

I have a problem with "Writer Properties" (Transformation). The "Advanced ETL" not update old records and insert new records. What am I doing wrong? See attachments.

Thanks,
Victor
Attachments:

Re: Updating Oracle table 10 months ago #3291

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Have you specified an update key?

Have a look at the chapter 10.15.7 How to Update/Delete Records

"In order to Update/Delete records you must specify update key.

Mike

Re: Updating Oracle table 10 months ago #3292

  • Victor
  • OFFLINE
  • Fresh Boarder
  • Posts: 5
  • Karma: 0
Mike

Thanks for the explanations. See the attachment. Can you do this?

Vic
Attachments:

Re: Updating Oracle table 10 months ago #3293

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Hello again.

It is already doing it.
Have look at the documentation 10.15.7 How to Update/Delete Records.

Mike
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

"The products are stable and the support is good. I would (and have) recommend to anyone needing to automate data management tasks or integrate disparate systems."

Gene Kovacs,
Director of Technical Business Operations,
A2B

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top