Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Why do flat file load is faster if you compare that with
table load ?
Please answer me.

Advance Thanks,
Manojkumar

Answer Posted / rayudu

another reason is that when we load the data into table
integration service also verifies data type and will do
parsing if needed. But in case of flat file there is no need
of parsing and checking data types.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do mean by local and global repository?

1150


what is unit testing?tell me proceedure

2164


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1991


Explain the features of connected and unconnected lookup.

875


Explain the code page compatibility?

1021


Explain the difference between a data warehouse and a data mart?

999


COM components can be used in Informatica

2312


Can we create a Integration service without a Repository service and vice versa?

1171


Is it possible to create multiple domains on a single Informatica server?

1179


Why union transformation is an active transformation?

993


How to partition the Session?

1040


What are the data movement modes in informatica?

1080


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1729


Explain why we use partitioning the session in informatica?

1005


what are 3 tech challenges/ common issues you face?

2278