Sorry if the Question is not too clear, can't think of a shorter way to write it.
I have a package which has two mappings, When mapping A is done, mapping B will run.
But the source table in mapping B is depending on the target table of mapping A.
For example in mapping A
Source table = A_START, and target table = A_FINISH
in mapping B
Source table = A_FINISH, and target table = B_FINISH
So mapping B depends on mapping A to finish first else the table would be empty.
The question here is, I ran the same package in two different environment (same package), the 1st environment has a slower server and the package for both mapping worked well. The 2nd environment has a faster server; both mapping ran successful BUT mapping B gives 0 record. I tried to see what might be the differences between both mapping and setup but can't find anything so something popped up which I doubted it and want to confirm I am wrong. Would the 2nd environment with faster server somehow started mapping B when mapping A_FINISH still has 0 records? Just that split second.
Else anyone has any suggestions where I can start looking which has a possible chance of causing this?