You can build such realtime pipelines in a way that messages are in order and guaranteed. Example for Kafka: Put all change rows of a subject matter into a single topic partition. Then the Order Header and Order Line Items both are loaded into the same topic partition and consistent hence.