Have a nice day!
Here I have many SQL SERVER databases which contain the same table, called "A" for example. Now I need to combinate all the "A" tables to the table "B", which has the same structure as "A" and stores in a Vectorwise database.
As far as I know, the "Database Reader" node can be used to read data from SQL SERVER databases and the "Database Writer" node can write data to the Vectorwise database. As there are many SQL SERVER databases, I need to create many "Database Reader" nodes. But the "Database Writer" node can only attach to one "Database Reader" node. So, how can I attach all of the "Database Reader" nodes to the same "Database Writer" node.
Beg your answers, thank you very much!