You are a database administrator for a financial firm. You receive data files from other financial firms.
Records inthese input files are delimited with a new line character, and column values are delimited with tab character.
You must validate the data in the input files, and insert the data into multiple tables.
To achieve this, you decide tomove the data to a local temporary table, and then read the data in the temporary table to insert the data into your database tables.
Which statement or tool will best suit your purpose in this scenario?