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:)