It's not uncommon that someone asks you to load a table that doesn't exist yet. The following are some use cases:
You could write a
CREATE TABLE statement from scratch and then create the transformation that loads the table, or you could do all that in an easier way from Spoon.
In this case, suppose that you received a file with data about countries and the languages spoken in those countries. You need to load the full content into a temporary table. The table doesn't exist and you have to create it based on the content of the ...