- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.2K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Is there a time gap between source and target of two mappings in a package?
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?