CRC32 VS Table level Data Comparision

Dear All,

I hv one query regarding comparision

Is File level data comparison is faster or Table level data comparision.

My source file generates around 6 gb Data at a time

Extraction is taking around 1 hour to complete and i m using crc32 function to load data into table.
As per my knowledge CRC32 does file level comparision and loades current new records into the table.


And it takes 4 times time of extraction to compare and load into table.

I have all latest technologies implemented in my setup.


Now i want to test table level comparision and file loading.

Please guide me the difference between file level comparision and table level comparision.

And how can i achieve the result in different ways also.


Thanks
Krishna:)