Home » Developer & Programmer » Warehouse Builder » can't delete data from extracts table (mapping) (10gr2)
can't delete data from extracts table (mapping) [message #319382] Sat, 10 May 2008 05:59 Go to next message
domisj
Messages: 4
Registered: May 2008
Location: Vilnius
Junior Member
hello,
i can't delete data from extracts table in mapping there is condition (i need to delete if it's the same batch_no in table and parameter): where gl_batch_no in (0,i_batch_no); (i_batch_no - is parameter)

table load type: delete/insert
conditional loading->target filter for delete: gl_batch_no in (0,gl_batch_no_1);

any suggestions?
Re: can't delete data from extracts table (mapping) [message #319586 is a reply to message #319382] Mon, 12 May 2008 05:35 Go to previous messageGo to next message
domisj
Messages: 4
Registered: May 2008
Location: Vilnius
Junior Member
Solved!
Re: can't delete data from extracts table (mapping) [message #319718 is a reply to message #319586] Mon, 12 May 2008 15:19 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's really nice, but noone (but you) knows what you did in order to solve the problem. The next user who gets into the same trouble won't be able to learn anything from your case.

So, would you mind to post the solution, please?
Re: can't delete data from extracts table (mapping) [message #319806 is a reply to message #319382] Tue, 13 May 2008 01:51 Go to previous message
indxe
Messages: 4
Registered: May 2008
Location: Jordan
Junior Member

Thats great ..... can you post the solution, just not to face the same problem in the future ...
thank you Smile
Previous Topic: Why we need Enqueue_Resources as 3000 to install OWB 10.2 Repository Server
Next Topic: Categorising information,
Goto Forum:
  


Current Time: Thu Apr 17 11:24:45 CDT 2014

Total time taken to generate the page: 0.12315 seconds