I had a job run successfully without any warnings or errors and yet had several records missing in the target table.
We ran the job again and it loaded all the records this time.
Anybody have any idea what could be the cause?
Thanks,
Spring
Missing data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Job uses Truncate and reload. Don't have any constraints in transformer other than doing lookup's.
We are using sql to compare source row count vs target row count.
we are running 3 different jobs inside single sequence in parallel with no connections or dependancy among these.
Seq looks like:
A job------>B job
G job------>H job
X job------>Y job
That's it.
The source data comes from different sources for all three jobs.
IN the above seq, A is a stored procedure that should be completed to run job B.
X is a sub sequence of multiple jobs to be completed before running job Y.
Wondering if it is ok to run these different jobs in same seq
Would that cause any DB contention.
Thanks,
Spring
We are using sql to compare source row count vs target row count.
we are running 3 different jobs inside single sequence in parallel with no connections or dependancy among these.
Seq looks like:
A job------>B job
G job------>H job
X job------>Y job
That's it.
The source data comes from different sources for all three jobs.
IN the above seq, A is a stored procedure that should be completed to run job B.
X is a sub sequence of multiple jobs to be completed before running job Y.
Wondering if it is ok to run these different jobs in same seq
Would that cause any DB contention.
Thanks,
Spring
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom