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.

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  

What is the function of aggregator transformation?

0 Answers  

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

How can we store previous session logs?

0 Answers  

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

What is a command that used to run a batch?

2 Answers  

How to delete duplicate records in a flat file source?

2 Answers