I've seen alot of talk about source tables, and target tables on the internet, but no definitions of what these things are…from what I can infer it seems to mean something about copying data from an old table with an old schema into a new table with a new schema…is this what it means?
A source table, and a target table
terminology
Best Answer
Essentially the source table is the place where the data is coming from and the target table is the place where the data is going to or the table that an action is taking place on. They do not have to be in different schema's or have a different structure to each other and in fact they could actually be the same table.