File vs table

[deva]

Hi I will get daily files which will be 2 mil records and we laod into teradata. Next day we will use as reference for next day. This process will reapete daily.

My question is about performence which way would be correct
1. loading the daily files into working tables and compare with target
or
2. directly compare the files with target tables(scd).

or

3. using teradata scripts to load the daily data into work tables and do the SCD?

which approch is the best way

[deva]

Hi I didn't receive any reply for my email. In datastage 8.1 or 8.5 we are using connectors . So which way is best for loading data into teradata table.

so what would be the difference between using connecters and using script for loading/miving data into files.