what goes to oracle enterprise stage's reject
Moderators: chulett, rschirm, roy
what goes to oracle enterprise stage's reject
I have an Oracle enterprise output stage in a job. What kind of errors in input records cause the records to go to the reject link of the stage? (the method of the stage is set to Upsert).
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can you please send me a small job that demonstrates a case, any simple one, where a bad input record goes to the reject link? With two input records, one bad, one good, and the Oracle table's DDL (two or three column).ray.wurlod wrote:The row from the input link plus an extra column called sqlcode. ...
My email is djonid@gmail.com.
Thanks a lot.
Djoni
I just shared your email with a friend who loves to bust mail servers with spamdjoni wrote:Can you please send me a small job that demonstrates a case, any simple one, where a bad input record goes to the reject link? With two input records, one bad, one good, and the Oracle table's DDL (two or three column).ray.wurlod wrote:The row from the input link plus an extra column called sqlcode. ...
My email is djonid@gmail.com.
Thanks a lot.
Djoni
![Laughing :lol:](./images/smilies/icon_lol.gif)
![Laughing :lol:](./images/smilies/icon_lol.gif)
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
your funny sud
djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible.
Your query is not that hard, at all. Pass two records with identical primary keys to a table with insert option. One will be inserted, the other will go down the reject link.
![Laughing :lol:](./images/smilies/icon_lol.gif)
djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible.
Your query is not that hard, at all. Pass two records with identical primary keys to a table with insert option. One will be inserted, the other will go down the reject link.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Even IBM Support could never make it workDSguru2B wrote:your funny sud![]()
djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible.
Your query is not that hard, at all. Pass two records with identical primary keys to a table with insert option. One will be inserted, the other will go down the reject link.
It's OK. Good luck with your friends trying to crack gmailDSguru2B wrote:your funny sud![]()
djoni, no one here is going to demonstrate to that elaborate extent due to time constraints. I suggest you go through formal training or work under an experienced developer to mentor your where in depth training and demostration is possible.
Your query is not that hard, at all. Pass two records with identical primary keys to a table with insert option. One will be inserted, the other will go down the reject link.
You are kidding ! It works and works big time. Just try it!!djoni wrote:IBM Support said the reject link did not work!!!sud wrote:haha hey djoni .. sorry, cudnt resist the temptation of cracking a jokeDSguru2B wrote:your funny sud![]()
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
For primary key being the same for two or more records, if you use Upsert method then you might not see rejects as the very first one will be inserted and the second and so on, will be updates. Choose upsert method and then you will see. I am surprised IBM said the reject does not work.
Last edited by DSguru2B on Fri Apr 27, 2007 7:32 pm, edited 1 time in total.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
When you have a reject link with Load, you can never remove the warning sign on the stage!DSguru2B wrote:For primary key being the same for two or more records, if you use Upsert method then you might not see rejects as the very first one will be inserted and the second and so on, will be updates. Chose load or just insert method and then you will see. I am surprised IBM said the reject does not work.
The reject link is applicable for Upsert only, applicable but does not work, that's it
All jokes apart, it WORKS. And yes, you are right, it is applicable only for upsert mode. Just try it, everybody uses it !! And, a sample from anyone will not help you since the db connections won't be valid at your end. Infact, what you are totally ignoring is that this is one of the most simple things to do. So just give it a try and if it doesn't work, we will walk you through it.When you have a reject link with Load, you can never remove the warning sign on the stage!
The reject link is applicable for Upsert only, applicable but does not work, that's it
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.