Answer / rayudu

One more thing is while loading the data into table
,informatica writes the data into database logs before
loading into target ,and this cant be done while loading a
flat file.

Answer / rayudu

hi,


Flat file doesn't contain any indexes or keys so it will
directly load into it. whereas in a table it will first
check for indexes and keys while loading into table so it is
slow when compared to flat file loading.



Regards,
rayudu.

Answer / joe

In case of dbases- time is consumed to make the dbase
connection for reading/writing data to the table.

Answer / 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.

Answer / ranjan

One more answer is in general flat files are kept on the server where informatica is installed.Thats the reason flat file loading is faster.

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

Answer / 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.

Answer / ankur saini er.ankur861@gmail.

Hi in case of teradata..IS have to take care of database
logs , and backup tables etc like transient journel etc
which makes it slow in case of table.

Answer / sanjay

While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.

Answer / manojkumar

Thanks Rayudu.

Is there any other reson why flat file load is faster than
table load.

I had an interview and even I said the same answer. But the
interviewer asked me "Is there any other reason ?" .
Interviewer didn't satisfied with this answer.

I hope there will be some other reason as well for this
question.
Anyways thanks for your reply.

What is A complex mapping?

3 Answers   TCS,

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

Enlist few areas or real-time situations where informatica is required.

0 Answers  

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

how to load rows into fact table in data warehouse

0 Answers   Informatica,

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

What is mapplet in informatica?

0 Answers  

How do you set a varible in incremental aggregation

0 Answers  

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

what is the difference between repository & Intergration service

1 Answers