...
To load or update data in Warehouse Cash Activity tables, send your CSV message to the eagle_default_in_csv_warehouse stream
Master/Original Transaction Number Logic
Single Mode Load
Values in the incoming file | Values loaded to DB |
---|---|
Both values are not set or missing originalTransactionNumber is NULL |
You will get the following error: Original Transaction Number cannot be null | |
Only original transaction number set originalTransactionNumber = FILLED | - masterTransactionNum copies the originalTransactionNumber value: - if |
you send the same message again, the values will remain the same (as from the file): - change originalTransactionNumber value to FILLED_B, once again masterTransactionNum copies this value and a new record |
will be created: | |
Both values are set: originalTransactionNumber = FILLED_C | - |
first load: values from file loaded into DB: |
- if you change originalTransactionNumber to FILLED_Е, the record will |
be updated updated with the new originalTransactionNumber value: |
- if you change masterTransactionNum |
to FILLED_F, the record will |
be updated with the new masterTransactionNum value: |
- if you change both: originalTransactionNumber to FILLED_G and masterTransactionNum to FILLED_H, a new record |
will be created: |
...
Batch Mode Load
If no masterTransactionNum value is provided in the loading file for load, the masterTransactionNum value will reflect the originalTransactionNumber value from the record:
Anchor | ||||
---|---|---|---|---|
|
...