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 / nidhi

To write data in table informatica server generate the insert statement for each row where as for flat file write the data row wise in file.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Informatica settings are available in which file?

990


Differentiate between sessions and batches?

1018


Define mapping and session?

1034


What is the command used to run a batch?

1062


What is DR strategy for Informatica project?

1185


Explain what transformation and how many are there in informatica?

955


What are the different types of repositories created using informatica?

1138


what is index?how it can work in informatica

2040


What are the different versions of informatica?

1275


On which transformations you created partitions in your project?

1348


how to load rows into fact table in data warehouse

1190


What is a repository manager?

1094


What is the need for an etl tool?

1068


What are the components of the workflow manager?

1135


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1632