both table are concatented into one table Holding all values. so 8 is the correct answer.
if you Need two table you have to define for table b
noconcatenate load ...
but then you have the same field in two tables and the result will be the same.
to get only the values of table A you need to gibt AccountID a different Name than
What is the Business issue? The current example makes no sense.