DSXchange

Thank you, Ray, for your hints. We have tried it very thoroughly and we found out the following: If you have 2 links writing to one ODBC stage, especially to one table, and if you are using different transaction sizes per link, then they are independent except for the transaction: One ODBC stage mea...

Thank you for the quick reply. To be sure that I am right: I have 1 connection, 2 transactions (one per link), possibly 2 threads (if links start from differents transformers). Imagine one link is "update" and the other one "insert" (e.g. Slowly Changing Dimensions 2 szenario): Then I have to use tr...

Hi, I have questions regarding an ODBC stage with 2 input links, both inserting into the same table. I can enter certain properties per input link, e.g. update action or transaction size. What happens if I define different transaction sizes for both input links (5000 and 1). Does the greater one ove...