DSXchange

Hi,

I am having 6 million of records in the source file.

Which one (DELIMITED OR FIXED WIDTH) is better to use as a source?

Can you please provide me some insight(advanatages & disadvantages) regarding this?

thanks and regards,
MCH

Fixed width is better in terms of being able to parse the contents, because substring is a far faster operation than scanning delimiters. Bulk loaders perform noticeably faster in a fixed-width regime, particularly where there are no VarChar fields in the table.

On the other hand, delimited can mean that you do not have to trim leading zeroes or trailing or leading space characters.

Like life, it's a compromise.