Hi All,
I have a following job design
sequential file -- transformer - Oracle enterprise stage.
I need to update the table incase of matching key columns otherwise i need to insert a new row.
but even if there are matching rows, it still inserts a new row resulting in duplicates.
i have verified key columns are of same type,
I ran the job with only one key column which is a char field of one length and still update is not working. pls help me to solve the problem,
There are no key columns in my table.
i am using auto generated update and Insert option.
Update not working
Moderators: chulett, rschirm, roy
Are you using custom SQL , and if so, please post it. If you are getting duplicate "key" columns, then most likely your table DDL is not correct. You might look at that and/post it here as well.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: Update not working
Are you doing "Insert then Update" or "Update then Insert"? (That's a setting in Oracle Stage btw, not a general query)ag_ram wrote:Hi All,
I have a following job design
sequential file -- transformer - Oracle enterprise stage.
I need to update the table incase of matching key columns otherwise i need to insert a new row.
but even if there are matching rows, it still inserts a new row resulting in duplicates.
i have verified key columns are of same type,
I ran the job with only one key column which is a char field of one length and still update is not working. pls help me to solve the problem,
There are no key columns in my table.
i am using auto generated update and Insert option.
Last edited by Kryt0n on Thu Sep 17, 2009 2:59 pm, edited 1 time in total.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am