Hi,
My requirement is such that the 1st 25 rows of oracle needs to be deleted everytime I run datastgae job to load Oracle. How do I achieve this?
Deleting 25 rows in Oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Mon Apr 21, 2008 1:49 am
-
- Participant
- Posts: 24
- Joined: Mon Jul 12, 2004 10:16 am
Re: Deleting 25 rows in Oracle
How do you define this first 25 rows? based on any key column or date and time of record creation?
-
- Participant
- Posts: 42
- Joined: Mon Apr 21, 2008 1:49 am
Re: Deleting 25 rows in Oracle
Yes it is based on a Key Column FTRJ, which is a string..Govindarajan wrote:How do you define this first 25 rows? based on any key column or date and time of record creation?
you can first join with thay oracle table....then using column generator generate sequence number in dummy column..then take first 25 records and delete from oracle...other records can be passed to other stream for updation/iserion.
though I must say it's very strange requirement. :D
you can do it this in two jobs as well...
you can also manipulate how toselect record for deletion
though I must say it's very strange requirement. :D
you can do it this in two jobs as well...
you can also manipulate how toselect record for deletion
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 42
- Joined: Mon Apr 21, 2008 1:49 am