I have the following situation in mapping (Informatica v6):
Source -> SQ -> Expression -> Target
Source -> SQ -> Expression -> Target
Source -> SQ -> Expression -> Target
Source -> SQ -> Expression -> Target
Each source is different but the target is the same table (just renamed logically each time).
The first question I have is: when this mapping is run, does each stream run sequentially starting at the first stream listed and working down or do all streams run simultaneously?
Based on the answer for above - if I checked on the "target truncate" field for stream #1, can I be sure that I'll always truncate the target before records are inserted from other streams?
Source -> SQ -> Expression -> Target
Source -> SQ -> Expression -> Target
Source -> SQ -> Expression -> Target
Source -> SQ -> Expression -> Target
Each source is different but the target is the same table (just renamed logically each time).
The first question I have is: when this mapping is run, does each stream run sequentially starting at the first stream listed and working down or do all streams run simultaneously?
Based on the answer for above - if I checked on the "target truncate" field for stream #1, can I be sure that I'll always truncate the target before records are inserted from other streams?