Hi,
Job fails While loading into oracle table if referential integrity for some records could not meet, thats fine. i can take those records into peek stage.
But i don't want to abort the job.
I am using reject records=true at oracle enterprise stage and passing into sharecontainer where it logges into some other table.
Please advice.
Don't want to abort job due to integrity constraints or any
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's no such thing as "collect in Peek stage".
Your ETL stream should (must) check that RI will not be violated. End of story. What you do with those rows is immaterial, so long as you don't send them to the target table.
Your ETL stream should (must) check that RI will not be violated. End of story. What you do with those rows is immaterial, so long as you don't send them to the target table.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.