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

Advance Thanks,
Manojkumar

Answer Posted / suresh

Here the records has to pass through the database drivers and ODBC connections are required, which is a time taking process.

But where as records from flat files are copied in easier way

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update source definition?

721


Explain the different lookup methods used in informatica?

686


what are factless facts? And in which scenario will you use such kinds of fact tables.

1411


Explain what is informatica metadata and where is it stored?

689


What is informatica worklet?

698






Enterprise data warehouse your projects phase by phase explain?

1562


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2010


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1621


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1399


What are the transformations that are not supported in mapplet?

680


What is the commit type if you have a transaction control transformation in the mapping?

735


How many types of sessions are there in informatica.please explain them?

774


What are connected or unconnected transformations?

721


What is expression transformation?

719


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1826