opbang

 Profile Answers by opbang 

• Oct 5th, 2006

 

Loading data from flatfiles to database is faster. You are receiving a data from a remote location. At remote location the required data can be converted into flatfile and same you can use at target location for loading. This minimizes the requirement of bandwidth, faster transmission.

Kapil

• Oct 11th, 2006

 

Hi Flat files have some advantages which normal table does not have. First one is explained by first post. Secondly, Flat file can work with case sensitivity issue of data easily., where normal table has errors.Kapil Goyal