Also, is there somewhere explained how does Meltano work? Does it load everything into memory and then pushes everything into the target? Is it extracting and loading partially?

Have you read the docs? Everything is based on singer, generally no things are not 100% in memory before loading into the target